DrillupMember

The MDX DrillupMember function for Essbase tests two sets for common ancestors and drills up members of the first set to the level of the ancestors that are present in the second set.

Syntax

DrillupMember ( set1, set2 )

Parameters

set1: The set containing members to drill up if comparison with set2 tests positive for identical members or tuples.
set2: The set to compare with set1 before drilling up members in set1.

Notes

This function drills up any members of set1 whose ancestors are found in set2. The level to which members in set1 are drilled up depends on the level of the ancestor found in set2. The resulting set contains the ancestors of the drilled up member at the level found in set2, as well as any members of set1 that were not drilled up.

Example

Example 1

The following example

DrillupMember({East, South, West, California, Washington, Oregon},{West})

returns the set:

{East, South, West}

The following expression

DrillupMember
 (
  {East, South, West, California, 
   Washington, Oregon, Central, Nevada},
  {West}
 )

returns the set:

{East, South, West, Central, Nevada}

The member Nevada is not drilled up to member West because another member Central interrupts the chain of West descendants.

Example 2

The following examples use the following part of the Sample Basic outline:

Expanded Product dimension with children 100, 200, etc, and children of 100: 100-10, 100-20, and 100-30.

The following expression

DrillupMember
 ({Product, [100], [100-10]}, 
  {[Product]}
)

returns the set:

{Product}

The following expression

 DrillupMember
  ({Product, [100], [100-10]}, 
   {[100]}
  )

returns the set:

{Product, [100]}