Note: | This information does not apply to attribute dimensions in duplicate member name outlines. For more information, see Setting Prefix and Suffix Formats for Member Names of Attribute Dimensions. |
To avoid generating duplicate member names across Boolean, date, and numeric attribute dimensions of the same database, you can define a method for automatically adding a prefix or a suffix to names of members of attribute dimensions.
For example, you can add the attribute dimension name as a suffix to the member name, separating the names by an underscore. As a result, in the Sample Basic database, the member 12 in the Ounces attribute dimension assumes the unique, full member name 12_Ounces.
The format that you specify applies to the level 0 member names of all numeric, Boolean, and date attribute dimensions in the outline. By default, member names in attribute dimensions do not have a prefix or suffix.
To define a prefix or suffix format for the names of members of Boolean, date, and numeric attribute dimensions:
Open the outline in edit mode and select the Properties tab.
Under Attribute settings, in the Prefix/Suffix Format option group, select the appropriate prefix or suffix format to use for attribute names.
Click OK.
“Setting Prefix and Suffix Formats for Member Names of Attribute Dimensions” in the Oracle Essbase Database Administrator's Guide
getattrinfo (ESSCMD) in the Oracle Essbase Technical Reference