DrilldownMember

Return to: Calculated Member Builder Function List

Drills down the members in a specified set that are present in a second specified set.

Alternatively, drills down on a set of tuples.

Syntax

DrilldownMember({«Set1»}, «Set2»[, RECURSIVE])

Remarks

Drills down the members in «Set1» that are present in «Set2». «Set1» is usually a subset of «Set2». If RECURSIVE is specified, the drilldown continues, comparing the expanded the result set against «Set2» at each step.

«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.

Example

DrilldownMember({USA, Canada, Mexico}, {USA, WA, Mexico})

returns the set

{USA, <all states in USA>, Canada, Mexico, <all states in Mexico>}

and

DrilldownMember({USA, Canada, Mexico}, {USA, WA, Mexico},RECURSIVE)

returns the set

{USA, <all states in USA before WA>, WA, <all cities in WA>, <all cities in USA after WA>, Canada, Mexico, <all states in Mexico>}.

Tuple drilldown

DrilldownMember({(USA,[Unit Sales]), (Canada,[Unit Sales]), (Mexico,[Unit Sales])},{USA, WA})

returns the set of tuples

{(USA,[Unit Sales]), (AZ,[Unit Sales]), ... , (WY,[Unit Sales]), (Canada,[Unit Sales]), (Mexico,[Unit Sales])}.

DrilldownMember({(USA,[Unit Sales]), (Canada,[Unit Sales]), (Mexico,[Unit Sales])},{USA, WA},RECURSIVE)

returns the set of tuples

{(USA,[Unit Sales]), (AZ,[Unit Sales]), ... (WA,[Unit Sales]), (<City1 in WA>,[Unit Sales]), ... (<CityN in WA>,[Unit Sales]), ... (WY,[Unit Sales]), (Canada,[Unit Sales]), (Mexico,[Unit Sales])}.