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.
DrillupMember ( set1, set2 )
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. |
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.
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.
The following examples use the following part of the Sample Basic outline:
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]}
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |