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 on one row or column.
To select members for data rows or columns:
To add members using the Select Members dialog box, take an action:
Select a dimension in the grid. Then in the formula bar, click the button 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.
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.
Optional: In the Selected area, review the selected members by clicking the View button, then selecting Preview. For more information, see Previewing Selected Members.
Optional: To insert a row or column for each selected member, select the check box, Place selections into separate rows (or Columns).
.
.