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.

You can access the following topics for information on the Select Members dialog box:

The following figure shows the Member Selection dialog box for the product dimension. The Available area shows the members, member lists, and functions available for the specified dimension. For information on updated functions, see Using Functions.

Figure 1. Member Selection Dialog Box

The image shows the Member Selection Dialog box.

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 (SSAS shows Name and Key). 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, then click OK..

With an SAP BW data source, you can use the View button to view a dimension hierarchy other than the one that is displayed. Or with an SSAS data source, you may want to change the default hierarchy from the currency property to organizations.

  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, then click OK.

    Note:

    The properties below the Available area are displayed only if you are reporting on Financial Management Organization by Period for the Entity dimension. The parent and the entities that belong to the parent are displayed.

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