Create a member set when you want to define a non-default
drill behavior. You specify what items respond to a drill action by
adding them to the member set.
Procedure
- Pause the pointer over the query explorer button and
click the query in which to create a member set.
- In the Properties pane, set the Define
Member Sets property to Yes.
- Double-click the query and click the Member
Sets tab.
- From the Source tab , drag items to
the work area.
To define a member set as a tree structure, drag the item that
will serve as the root item of the set to the work area, and then
drag other items over the root item to create the tree structure.
Note: You can also nest member sets.