Description:
This function is used to return the set of the ascendants of a specified member, including the member itself.
Syntax:
Ascendants(Member_Expression)
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
| Code Block | ||
|---|---|---|
| ||
select [Measures].[Internet Sales Amount] on columns,ascendants([Customer].[Geography].[City].&[Australia]&[New South Wales]&[Goulburn])
on rows from [AdventureWorksMF] |