ISLEVEL
Description:
The MDX IsLevel function returns TRUE if the member is in a specified level.
Syntax:
IsLevel ( Member_Expression, Numeric_Expression )
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Numeric_Expression | The MDX member to apply the function to. |
Member_Expression | The MDX member to apply the function to. |
Example:
WITH MEMBER [Measures].[Result] AS ISLEVEL([Dimensions].[Hierarchy].CURRENTMEMBER, 2) SELECT [Measures].[Result] ON 0 FROM [CubeName]