Using the Select Members Option

The Select Members option enables you to perform more advanced member selection.

To perform an advanced member selection:

1.      Click on the dimension heading and select Select members from the dimension menu, or click Members in the Dimension tab of the ribbon.

 

2.      In the Select Members in <Dimension> dialog box, click on a member in the All Members panel and click the arrow to move it to the Selected panel, or just double-click a member.

 

To deselect members in the Selected panel, double-click them. They will move back to the All Members panel.

To search for a member, click Search , type in the search text and click the filter  button (or press Enter).

Select Allow drill down on selected members if you want to allow drilling down to lower levels of hierarchy for the selected members.

When the Show caption option is selected only the member names display. When deselected, only the parents are displayed.

 

 

3.      Click OK.

The grid and chart now display only the selected members. A filter  icon appears in the heading of the dimension indicating that a member selection has been performed in that dimension.