1. Calculation and Query Reference for Oracle Essbase
  2. MDX
  3. MDX Syntax and Specification
  4. MDX Hierarchy Specification

MDX Hierarchy Specification

In an Essbase aggregate storage (ASO) database, a hierarchy is the root member of an alternate hierarchy, which is always at generation 2 of a dimension. Some MDX functions accept a hierarchy specification as input.

Alternate hierarchies are applicable to aggregate storage databases only.

The following MDX functions accept a hierarchy argument. Member value expressions are not allowed as hierarchy arguments in MDX.

  • Ancestor()
  • FirstSibling()
  • LastSibling()
  • Lead()
  • Lag()
  • ParallelPeriod()
  • Parent()
  • LinkMember()
  • MemberRange()
  • PeriodsToDate()
  • LastPeriods()
  • RelMemberRange()

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.