DRILLDOWNMEMBERBOTTOM

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 also drills down on a set of tuples by using the first tuple hierarchy or the optionally specified hierarchy.

Syntax:

DrillDownMemberBottom(<Set_Expression1>, <Set_Expression2>, <Count> [,[<Numeric_Expresion>] [,[<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,
    DrilldownMemberBottom(
        { [Customer].[Geography].[Country].&[Australia],[Customer].[Geography].[Country].&[Canada]  },
        { [Customer].[Geography].[Country] },
        3,
        [Measures].[Internet Order Quanlity]
    ) ON 1
FROM
    [AdventureWorksMF]