DRILLDOWNLEVELTOP
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
This function is used to drill down the topmost members of a set at a specified level to one level below.
Syntax:
DrilldownLevelTop(<Set_Expression>, <Count> [,[<Level_Expression>] [,[<Numeric_Expression>][,INCLUDE_CALC_MEMBERS]]])
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Count | It is a valid numeric expression that specifies the number of tuples to be returned. |
Level_Expression | It is a valid MDX expression that returns a level. |
Numeric_Expression | It is a valid numeric expression is typically an MDX expression of cell coordinates that returns a number. |
Include_Calc_Members | It is a keyword that adds calculated members to drilldown results. |
Example:
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
DrilldownLevelTop([Product].[Product Categories].[Category].Members, 3, , [Measures].[Internet Sales Amount]) ON ROWS
FROM [AdventureWorksMF_ValueBased]