ALLMEMBERS
By Hierarchy_Expression
Description:
This function is used to evaluate a hierarchy expression and returns a set that contains all members of the specified hierarchy, which includes all calculated members in the hierarchy.
Syntax:
Hierarchy_Expression.AllMembers
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Example:
SELECT
[Measures].[Internet Order Quanlity] ON columns,
Non empty [Date].[Calendar].AllMembers ON rows
FROM
[AdventureWorksMF]By Level_Expression
Description:
This function is used to evaluate a level expression and returns a set that contains all members of the specified level, which includes all calculated members in the level.
Syntax:
Level_Expression.AllMembers
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Level_Expression | It is a valid MDX expression that returns a level. |
Example:
SELECT
[Measures].[Internet Order Quanlity] ON columns,
[Date].[Calendar].[Calendar Year].AllMembers ON rows
FROM
[AdventureWorksMF]