Modifying Member Selection Using the Formula Bar

When working with members in a grid, you can use the formula bar to modify the selected members.

To modify member selection using the formula bar:

  1. In a grid, select a heading cell of a data row or column.
  2. Click the button for the dimension next to the formula bar.
  3. In the Select Members dialog box, select or remove members.

    The new members are displayed in the grid. For information on member selections, see Assigning Members Using Functions.

  4. Click Validate button to accept the member entry.

    The grid is set to obtain data for the new member/member function.

When modifying member selection using the formula bar, keep in mind the following points:

  • Member names in the formula bar is not case-sensitive.

  • A member function can be entered dynamically on data heading cells. See Assigning Members Using Functions.

  • You cannot combine numerical functions with member functions; for example, Sum(Children of (Product) (Inclusive)).