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 |
|---|---|
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 Sales Amount] ON COLUMNS, DrilldownMember([Product].[Product Categories].[Category].Members, {[Product].[Product Categories].[Category].&[Bikes], [Product].[Product Categories].[Category].&[Accessories]}) ON ROWS
FROM [AdventureWorksMF_ValueBased]