Assigning Members to Data Rows or Columns

You assign members and member lists to retrieve data for your reports. You can select members to be displayed in your report, or you can use functions to select dimension members dynamically. You can insert a separate row or column in a grid for each selected member, or you can place all of the selected members in one row or column.

  To assign members to data rows or columns:

  1. Open a report.

  2. In the Select Members dialog box, select a dimension.

    You can either double-click a dimension in the grid, or select a dimension in the grid and click the button in the formula bar with the dimension name.

    If you know the member names for a dimension, enter the member names, separated by commas, into the formula bar text area. Case sensitivity is enabled for member names, however it is not enabled for function names. For example, for the Measures dimension you might enter children of (Profit), then click the check mark to verify the member names.

  3. Assign members, member list, or functions.

    • To assign individual members, select the Members tab, then highlight the members to add to the data row or column.

    • To assign member lists, select the Lists tab, then highlight the member lists to add to the data row or column.

    • To assign functions, select the Functions tab, then highlight the functions to add to the data row or column.

  4. Add the highlighted items to the Selected area (click Right Arrow icon), or add a member function (children, descendents, and so on) to a selected member, click Function icon

    The Add Relationship button is available only on the Members tab.

  5. Optional: In the Selected area, review the selected members by clicking View, and then selecting Preview.

    For more information, see Previewing Selected Members.

  6. Optional: To insert a row or column for each selected member, select Place selections into separate rows (or Columns).

    This option is available only in the Select Members dialog box.

  7. Click OK to return to the Report Designer.