fbpx

Root (MDX)

Returns a tuple containing the ALL members of the specified hierarchies. If ALL member does not exist the default member is used.

Parameters

Name Type Cardinality Default value
  dimension-hierarchy-tuple-expression  zero-one   

Return

tuple

Description

Returns a tuple containing the ALL members of the specified hierarchies. If ALL member does not exist the default member is used.

1) Root() returns a tuple for all hierarchies (including Measure).
2) Root(Dimension) returns a tuple with hierarchies of the specified dimension.
3) Root(Hierarchy) returns a tuple with hierarchies of the specified hierarchy dimension.
4) Root(Tuple) return a tuple completed with all missing hierarchies of the specified tuple hierarchies.

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.