DRILLDOWNMEMBER

Description:

This function is used to drill down the members in a specified set that are present in a second specified set.

Syntax:

DrillDownMember(<Set_Expression1>, <Set_Expression2> [,[<Target_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.
Target_Hierarchy	It is a valid MDX expression that returns a hierarchy.
Numeric_Expression	It is a keyword that indicates recursive comparison of sets.
Include_Calc_Members	It is a keyword that adds calculated members to drilldown results.

Example:

SELECT 
[Measures].[Internet Order Quanlity] on 0,
DrilldownMember   
   ( [Customer].[Geography].Children,  
      {[Customer].[Geography].[Country].&[Australia],  
        [Customer].[Geography].[State-Province].&[Australia]&[Victoria]}  
   ,RECURSIVE)  
   ON 1  
   FROM [AdventureWorksMF]