DRILLDOWNMEMBERTOP
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 members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, this function drills down on a set of tuples by using the first tuple hierarchy or the optionally specified hierarchy.
Syntax:
DrillDownMemberTop(<Set_Expression1>, <Set_Expression2>, <Count> [,[<Numeric_Expression>] [,[<Hierarchy>]] [,[RECURSIVE][,INCLUDE_CALC_MEMBERS]]])
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression1 | It is a valid MDX expression that returns a set. |
Set_Expression2 | 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. |
Numeric_Expression | It is a keyword that indicates recursive comparison of sets. |
Hierarchy | It is a valid MDX expression that returns a hierarchy. |
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, DrilldownMemberTop([Product].[Product Categories].[Category].Members, {[Product].[Product Categories].[Category]}, 2, [Measures].[Internet Sales Amount]) ON ROWS
FROM [AdventureWorksMF_ValueBased]