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
-
Click the Queries icon , and click the query in which to create a member set.
-
Click the Show properties icon , and In the Properties pane, set the Define member sets property to Yes.
-
Double-click the query and click the Member sets tab.
-
Click the Insertable objects icon , and from the Data items 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.