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].[Is Category Level] AS
[Product].[Product Categories].CurrentMember.IsLevel([Product].[Product Categories].[Category])
SELECT
{[Measures].[Internet Sales Amount], [Measures].[Is Category Level]} ON COLUMNS,
[Product].[Product Categories].[Category].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]