Analysis Services
ToggleDrillState
Toggles the drill state of members.
Syntax
ToggleDrillState(«Set1», «Set2»[, RECURSIVE])
Remarks
This function is a combination of DrillupMember and DrilldownMember. It toggles the drill state of each member of «Set2» that is present in «Set1». If a member m of «Set2» that is present in «Set1» is drilled down (that is, has a descendant), DrillupMember(«Set1», {m}) is applied. If it is drilled up (that is, there is no descendant of m that immediately follows m), DrilldownMember(«Set1», {m}[, RECURSIVE]) is applied to Set1. The optional RECURSIVE flag is used if ToggleDrillState was called with RECURSIVE.
Example
ToggleDrillState({Product.Bread.Members},{Product.Bagels, Product.Muffins}, RECURSIVE)