MEMBERS
1. MEMBERS (Syntax: Hierarchy_Expression.Members)
Description:
This function is used to return the set of members in a dimension, level, or hierarchy.
Syntax:
Hierarchy_Expression.Members
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,
[Customer].[Geography].Members ON ROWS
FROM
[AdventureWorksMF]2. MEMBERS (Syntax: Level_Expression.Members)
Description:
This function is used to return the set of members in a dimension, level, or hierarchy.
Syntax:
Level_Expression.Members
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,
[Customer].[Geography].[Country].Members ON ROWS
FROM
[AdventureWorksMF]3. MEMBERS (Syntax: Members(Member_Name))
Description:
Returns a member specified by a string expression.
Syntax:
Members(Member_Name)
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Member_Name | It is a valid string expression that specifies a member name. |
Example:
SELECT
[Measures].[Internet Order Quanlity] ON COLUMNS,
Members('[Customer].[Geography].[Country].&[United States]')ON ROWS
FROM [AdventureWorksMF]