ASCENDANTS
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:
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
Ascendants([Product].[Product Categories].[Sub Category].&[Bikes]&[Road Bikes]) ON ROWS
FROM [AdventureWorksMF_ValueBased]