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.

The following example shows a textual modification of member selection using the formula bar.

Note:

The entry of member names in the Formula Bar is not case-sensitive.

First, you select the heading cell in the grid. The dimension is displayed in the button on the Formula Bar. Next, you can use the Formula Bar to dynamically enter the member function for the selected dimension.

Note:

A member function can be entered dynamically on data heading cells. For more information on member functions and syntax, see Assigning Members Using Functions.

  To modify member selection using the formula bar:

  1. Open or create a report.

  2. Select a heading cell of a data row or column in the grid.

  3. On the formula bar, click the dimension button, then use the Select Members dialog box to select or remove members.

    The new members are displayed in the grid. For information on using member selections, see Defining Members.

    Note:

    When you select a member in the grid, the dimension button on the formula bar is activated. You must indicate a member that exists within the current dimension.

    • Modify the member name(s) in the text box on the formula bar.

    • Dynamically enter a member function for a dimension using the formula bar.

      Note:

      You cannot combine the use of numerical functions with member functions; that is, Sum(Children of (Product) (Inclusive))

  4. Click Validation icon to accept the member entry.

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