DrilldownMember
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
This function 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 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
These examples drill down into members.
This example
DrilldownMember({USA, Canada, Mexico}, {USA, Washington, Mexico})
returns the set:
{USA, <all states in USA>, Canada, Mexico, <all states in Mexico>}and this example
DrilldownMember({USA, Canada, Mexico}, {USA, Washington, Mexico},RECURSIVE)
returns the set:
{USA, <all states in USA before Washington>,
WA, <all cities in Washington>, <all cities in USA after Washington>,
Canada, Mexico, <all states in Mexico>}.
The following examples drill down into tuples.
This example
DrilldownMember({(USA,[Unit Sales]), (Canada,[Unit Sales]),
(Mexico,[Unit Sales])},{USA, Washington})
returns the set of tuples:
{(USA,[Unit Sales]), (Arizona,[Unit Sales]), ... , (Wyoming,[Unit Sales]),
(Canada,[Unit Sales]), (Mexico,[Unit Sales])}.
and this example
DrilldownMember({(USA,[Unit Sales]), (Canada,[Unit Sales]),
(Mexico,[Unit Sales])},{USA, Washington},RECURSIVE)
returns the set of tuples:
{(USA,[Unit Sales]), (Arizona,[Unit Sales]), ... (Washington,[Unit Sales]), (<City1 in Washington>,[Unit Sales]), ... (<CityN in Washington>,[Unit Sales]), ...
(Wyoming,[Unit Sales]), (Canada,[Unit Sales]), (Mexico,[Unit Sales])}.