Adding Suffixes to Members

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

Note:

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

To add a prefix to a member, see Adding Prefixes to Members.

For information on members, see Members Overview.

  To add a suffix 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 Suffix option from the drop-down list:

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

      Note:

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

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

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

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

      Note:

      Selecting All ancestors' names for a suffix may produce a lengthy suffix. 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 suffix to the alias name.

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

  4. Optional: Select a Suffix separator to separate the suffix from the alias.

  5. Optional: Type a custom suffix in the Custom suffix text box.

    Note:

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

    Note:

    Some special characters are not allowed in suffixes. 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.