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 )
Parameter | Description |
---|---|
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
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]}