DRILLDOWNLEVELTOP

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

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 Order Quanlity] on 0,
DrilldownLevelTop   
   ([Product].[Product Categories].children,  
   3,  
   [Product].[Product Categories].[Category])  
   ON 1 
   FROM [AdventureWorksMF]