Setting Attribute Member Names Format

You can ensure that an attribute name is unique by assigning a prefix or suffix. Note that an outline does not display the full attribute member name after you have assigned a prefix or suffix identifier. You can view the full attribute names when you retrieve information; for example, full attribute names are displayed when you view a spreadsheet.

  To set the format for attribute member names in an Essbase model:

  1. Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.

  2. Select the Attributes tab.

  3. Locate the Member name format group.

  4. Select a Value to be used as a prefix or suffix:

    Note:

    You can attach both a prefix and a suffix to a member name.

    • None

    • Parent

    • Grandparent

    • Ancestor

    • Dimension

  5. Select a Separator to be used with the prefix or suffix:

    • Underscore

    • Pipe

    • Caret

  6. Select a Prefix or Suffix to define whether the selected value is to be used as a prefix or a suffix.

    The Sample field displays an example attribute name based on the selections you have chosen.

  7. 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.