DrillupMember

Analysis Services

Analysis Services

DrillupMember

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

Syntax

DrillupMember(«Set1», «Set2»)

Remarks

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

Example

This example

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

returns the set

{Canada, Mexico, USA, Washington}.