DrillupMember

Return to: Calculated Member Builder Function List

Drills up the members in a specified set that are present in a second specified set.

Syntax

DrillupMember(«Set1», «Set2»)

Remarks

Drills up the members in «Set1» that are present in «Set2». «Set2» is usually a subset of «Set1».

Example

DrillupMember({Canada, Mexico, USA, WA, Seattle},{WA})

returns the set

{Canada, Mexico, USA, WA}.