Return to: Calculated Member Builder Function List
Drills 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, drills down on a set of tuples.
DrilldownMemberTop(«Set1», «Set2», «Count»[, «Numeric Expression»][, RECURSIVE]])
«Set1» may contain tuples instead of members. Tuple drilldown is an extension of OLE DB, and it returns a set of tuples instead of members.
Functions like DrilldownMember does, but instead of including all children of a member, only the top «Count» number of children are returned, based on «Numeric Expression».
DrilldownMemberTop({USA, Canada, Mexico}, {USA, WA, Mexico}, 2, [Unit Sales])
returns the set
{USA, <top two states in USA>, Canada, Mexico, <top two states in Mexico>}
and
DrilldownMemberTop({USA, WA, Canada, Mexico}, {USA, WA, Mexico}, 2, [Unit Sales], RECURSIVE)
returns the set
{USA, WA, <top two cities in WA>, Canada, Mexico, <top two states in Mexico>}.
Tuple drilldown
DrilldownMemberTop({(USA, [Unit Sales]), (WA, [Unit Sales]), (Canada, [Unit Sales]), (Mexico, [Unit Sales])},{USA, WA},2,[Store Sales],RECURSIVE)
returns the set
{(USA, [Unit Sales]), (WA, [Unit Sales]), (<top two cities in WA>, [Unit Sales]), (Canada, [Unit Sales]), (Mexico, [Unit Sales]}.