DrilldownMember

Drills down on any members or tuples of set1 that are also found in set2. The resulting set contains the drilled-down members or tuples, as well as the original members or tuples (whether they were expanded or not).

Syntax

DrilldownMember( set1, set2 [, RECURSIVE] )

set1 The set containing members or tuples to drill down on if comparison with set2 tests positive for identical members or tuples.
set2 The set to compare with set1 before drilling down on members or tuples in set1.
RECURSIVE Optional. A keyword to enable repeated comparisons of the sets.

Description

This function drills down on all members of set1 that are also found in set2. The two sets are compared. Then the members or tuples of the first set that are also present in the second set are expanded to include their children.

If the first set is a list of tuples, then any tuples in the first set that contain members from the second set are expanded to their children, generating more tuples.

If the RECURSIVE keyword is used, multiple passes are made on the expanded result sets. Drilldownmember repeats the set comparison and resulting drilldown until there are no more unexpanded members or tuples of set1 that are also present in set2.

Example

Drilling Down on Members
Drilling Down on Tuples

Drilling down on Members

The following examples drill down on members.

Example 1

The following expression

DrilldownMember({East, West, South}, {East, Washington, California})

returns the set:

{ East, [New York], Massachusetts, Florida, Connecticut, [New Hampshire],
  West, South }

Therefore, the following query

SELECT
DrilldownMember({East, West, South}, {East, Washington, California})
ON COLUMNS
FROM Sample.Basic
  

returns the grid:

East New York Massachusetts Florida Connecticut New Hampshire West South
24161 8202 6712 5029 3093 1125 29861 13238

Example 2

The following expression

DrilldownMember({Market, [New York]}, {Market, West}, RECURSIVE)

returns the set:

{Market, East, West, California, Oregon, Washington, Utah, Nevada, South,
 Central, [New York]}

The member Market is drilled down and then the West member of the resulting set is drilled down, because the RECURSIVE parameter was specified.

Drilling Down on Tuples

This example uses the following part of the Sample Basic outline:

The following example drills down on tuples.

The following expression

DrilldownMember
 ( {([100],[California]), ([200],[Washington])},
   { [100] }
 )

returns the set of tuples:

{ ([100],California), ([100-10],California), ([100-20],California),
 ([100-30],California), ([200],Washington)}

Therefore, the following query

SELECT
DrilldownMember
 ( {([100],[California]), ([200],[Washington])},
   { [100] }
 )
ON COLUMNS
FROM Sample.Basic
  

returns the grid:

100 100-10 100-20 100-30 200
California California California California Washington
999 3498 -1587 -912 1091

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com