Browsing Members

  To browse and select members:

1. In the data layout, on the shortcut menu, select a dimension member and select Edit.

   The Member Selection dialog box is displayed.

2. Select Browse.

3. Select a member and click + to the left of the member name to expand it.

4. To include an individual member in the query, select the member in the Available pane and click .

   The member is added to the Selected pane.

5. To include a dynamic function, on the shortcut menu, select the member in the Available pane and select the function from the submenu:

   • Member

   • Children

   • Descendants

   • Bottom

   • Siblings

   • Same Level

   • Same Generation

   • Disable or Enable (selected members only)

6. Click OK.

  To change the member function in the Selected pane:

1. Select the member to modify.

   Use Shift + click to select multiple and consecutive items. Use Ctrl + click to select multiple, but nonconsecutive items.

2. To include or exclude a member (for example, “Member+Children” versus “Children”), select the check box next to the member name.

3. Click OK.

  To clear an item used in the query without removing it from the Selected pane:

1. Select the item and choose Disable from the shortcut menu.

2. Click OK.

  To remove a member or member element:

1. Select the member in the Selected pane and click .

   Use Shift + click to select multiple and consecutive items. Use Ctrl + click to select multiple, but nonconsecutive items.

   The member is moved from the Selected pane.

2. Click OK.

  To remove all members and member elements, select .

The Selected pane is depopulated.

  To toggle between including or excluding a member:

1. Select a member in the Selected pane.

2. Select Disable to exclude a member, or Enable to include a member.