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 Order Quanlity] on 0,
DRILLDOWNLEVEL({[Product].[Product Categories].[Category]} * {[Sales Territory].[H_Sales Ter]},,0) ON 1
FROM [AdventureWorksMF]