Adding Prefixes to Members

You can add a prefix or a suffix or both to a member.

Note:

Prefixes and suffixes are not supported when the member is from a text file source.

To add a suffix to a member, see Adding Suffixes to Members.

For information on members, see Members Overview.

  To add a prefix to a member name:

  1. Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.

  2. Select the Transformations tab.

  3. Select a Prefix option from the drop-down list:

    • None—No prefix will be added to the member.

      Note:

      Select None if you plan to use a custom prefix as described in step 5, below.

    • Parent name—The name of the parent of the member will be added as a prefix to the member.

    • Grandparent name—The name of the grandparent of the member will be added as a prefix to the member.

    • All ancestors' names—All names of all ancestors of the member will be added as a prefix to the member name.

      Note:

      Selecting All ancestors' names for a prefix may produce a lengthy prefix. Member names are limited to 80 characters.

    • Dimension name—The name of the dimension in which the member is located will be added as a prefix to the member.

    A preview of the member name after the prefix is added is displayed in the text box just below the Custom prefix text box.

  4. Optional: Select a Prefix separator to separate the prefix from the member.

  5. Optional: Enter a custom prefix in the Custom prefix text box.

    Note:

    If you enter a custom prefix, be sure you have selected None in the Prefix drop-down list as described in step 3, above.

    Note:

    Some special characters are not allowed in prefixes. See Naming Restrictions for Essbase Studio.

  6. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.