Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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])}.