DRILLDOWNMEMBERTOP

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

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 Order Quanlity] on 0,
  DrilldownMemberTop   ({[Product].[Product Categories].[Product],        
[Product].[Product Categories].[Category].&[Accessories],        
[Product].[Product Categories].[Category].&[Clothing]},     
{[Product].[Product Categories].[Category]},     
3,     
[Measures].[Average RateM])     
ON 1    
FROM [AdventureWorksMF]