DRILLDOWNLEVEL
Description:
This function is used to drill down the members of a set to one level below the lowest level represented in the set.
Syntax:
DrilldownLevel(Set_Expression [,[Level_Expression] ,[Index]] [,INCLUDE_CALC_MEMBERS])
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a member. |
Level_Expression | It is an MDX expression that explicitly identifies the level at which to drill down. If you specify a level expression, skip the below index argument. |
Index | It is a valid numeric expression that specifies the hierarchy number to drill down into within the set. You can use the index level instead of Level_Expression to explicitly identify the level at which to drill down. |
Include_Calc_Members | It is a flag indicating whether to include calculated members, should they exist, at the drill-down level. |
Example:
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
DrilldownLevel([Product].[Product Categories].[Category].Members) ON ROWS
FROM [AdventureWorksMF_ValueBased]