Select Members Dialog Box

You use the Select Members dialog box to define your data rows and columns and to define the members on the page axis. You can select members, create and save member lists, and select functions that dynamically retrieve members from the database connection.

Note:

Substitution variables are placed in a directory.

The Selected area shows the names and descriptions of the members you selected for most data sources . You can rearrange the display of the columns in the Available and Selected areas of the Select Members dialog box by dragging the column headings. You can also add columns to the display.

  To add columns to the display:

  1. Click the View button above the area where you want to add the columns.

    For example, to add columns to the Available area, click the View button above the Available area.

  2. Select the Show option

  3. Select the columns to add to the display, and then click OK.

  To view a hierarchy other than the one that is displayed:

  1. Click a hierarchical dimension in the Available area.

  2. Click the View button above the Available area.

  3. Select the Hierarchy option.

  4. Select the hierarchy you want to view, and then click OK.

When you run a report, the parent name is not displayed; only the entity name is displayed.