Assigning Members Using Functions

You can use functions to select members dynamically. After you select a function, you can edit its parameters.

To assign members using functions:

  1. Open a report and select a grid.
  2. Double-click a dimension cell.
  3. In the Select Members dialog box, select the Functions tab.
  4. Highlight one or more functions, and then click Add to Selected button..

    You cannot select functions that do not require parameter values, such as BottomofHierarchy, TopofHierarchy, AllMembers, and SuppressSharedMembers.

  5. Select a function, and then click Add to Selected button.
  6. Click Lookup Selection, and the select the members to add to the function.