fbpx

Ancestors (MDX)

Returns the ancestor of a specified member at a specified level or distance as a set. Same as Ancestors.

Parameters

Name Type Cardinality Default value
  member-expression  one   
level/distance  level-numeric-expression  one   

Return

set

Description

Despite the 's' in its name this function is equivalent to Ancestor.

See Also

Ancestor Ascendants IsAncestor

Examples

Special Examples (errors, null, ...)

XMLA Properties

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