Adding Members to Dimensions

Members are the individual components of the outline. Unless the dimension is enabled for duplicate member names, each member has a unique name. A dimension can contain an unlimited number of members, and members can be nested under other members. For more information about members, see the Oracle Essbase Database Administrator's Guide.

In a duplicate member name outline, each dimension allows duplicate member names by default. To add a duplicate member name, simply type the duplicate member name. There are no additional requirements for adding a duplicate member. If the outline is not enabled for duplicate members, an error is returned when a duplicate member name is entered.

Note:

If you add, delete, or change dimensions and then save the outline, Essbase needs to restructure your database. After the restructuring is complete, you must recalculate the data.

  To add members to an outline:

  1. Open the outline in edit mode.

  2. Perform an action:

    • To add a member as a child of a dimension or another member, select the dimension or member, right-click, and select Add child.

    • To add a member as a sibling of another member or dimension, select the member or dimension, right-click, and select Add sibling.

  3. Enter the member name, following the proper naming rules, and press Enter.

    After you press Enter, a text box is displayed, to add an additional sibling member. To close the text box without entering a name, press Enter again or press Esc.

  4. Define the member properties for all new members and dimensions.

Related Information