This section describes how to create and use hierarchy expressions in DeepSee MDX.
In DeepSee MDX, a hierarchy expression has one of the following forms:
A hierarchy literal, which is a direct reference to the hierarchy as follows:
A reference to a dimension:
DeepSee interprets this as a reference to the first visible hierarchy of that dimension.
An expression that uses a DeepSee MDX extension to refer to a hierarchy in another cube, via the following syntax:
A bare hierarchy expression returns all records; this expression is equivalent to an All member. (Note that you can use a bare hierarchy expression even if the dimension does not formally define an All level.) For example:
SELECT MEASURES.[%count] ON 0, colord.h1 ON 1 FROM patients
Also, you can use a hierarchy expression as an argument to any of the following functions: