MDX Hierarchy Specification

In an Essbase aggregate storage database, a hierarchy is the root member of an alternate hierarchy, which is always at generation 2 of a dimension.

Alternate hierarchies are applicable to aggregate storage databases only.

Some MDX functions accept a hierarchy argument. To learn which ones, see MDX Grammar Rules and search for <hierarchy>. Member value expressions are not allowed as hierarchy arguments in MDX.

The dimension of the hierarchy argument passed to a function must match the dimension of the other arguments passed to the function. If they do not match, an error is returned, and the query is aborted.