LEVELS
1. LEVELS (Syntax: Hierarchy_Expression.Levels( Level_Number) )
Description:
This function is used to return the level whose position in a dimension or hierarchy is specified by a numeric expression.
Syntax:
Hierarchy_Expression.Levels( Level_Number)
Return Type:
LEVEL
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Level_Number | It is a valid numeric expression that specifies a level number. |
Example:
WITH MEMBER Measures.x AS
[Customer].[Geography].Levels(1).uniqueName
SELECT Measures.x ON 0
FROM [AdventureWorksMF]2. LEVELS (Syntax: Hierarchy_Expression.Levels( Level_Name ))
Description:
This function is used to return the level whose name is specified by a string expression.
Syntax:
Hierarchy_Expression.Levels( Level_Name )
Return Type:
LEVEL
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Level_Name | It is a valid string expression that specifies a level name. |
Example:
WITH MEMBER Measures.x AS
[Customer].[Geography].Levels(1).uniqueName
SELECT Measures.x ON 0
FROM [AdventureWorksMF]