When naming dimensions, members, and aliases, follow these rules:
Use no more than 80 characters for dimension, member, or alias names.
Dimension names that are the same name as a member property or a column header in the metadata load file (for example, Data Type) cannot be used.
HTML tags cannot be used in member names, dimension names, aliases, and descriptions.
The TAB key is restricted and cannot be used in dimension, member, and alias names.
The following is a list of characters that are restricted and cannot be used in dimension, member, and alias names:
Table A-2 Restricted Characters in Dimension, Member, and Alias Names
Brackets [ ] are permitted but not recommended in block storage outlines. They cause errors when converting to aggregate storage outlines.
The following is a list of characters that cannot be used at the beginning of dimension, member, and alias names:
Table A-3 Restricted Characters at the Beginning of Dimension, Member, and Alias Names
dash, hyphen, or minus sign
less than sign
Member names with the preceding characters are not allowed in Planning data export jobs.
Spaces cannot be placed at the beginning or end of names.
For time periods in custom calendars, don't use spaces in prefixes.
Shared members must have the same names as their base member. Also, base and shared member names are case-sensitive.
The following cannot be used as dimension, member, or alias names:
Calculation script commands, operators, and keywords
Function names and function arguments
Names of other dimensions and members (unless the member is shared)
If Dynamic Time Series is enabled, don't use History, Year, Season, Period, Quarter, Month, Week, or Day.
In unique member outlines that contain an attribute dimension, you cannot use Sum, Count, Min, Max, and Avg as member or dimension names. Using these names causes duplicate name conflicts.
The members that are created in the attribute calculations dimension (Sum, Count, Min, Max, and Avg) are not considered reserved words because you can change these names in the attribute calculations dimension and then use the standard name in an attribute or standard dimension.
If the outline is tagged as a unique member outline, avoid using Sum, Count, Min, Max, and Avg as member names. For example, if you use Max in a standard dimension and then create an attribute dimension, in which the Max member in the attribute calculations dimension are created, a duplicate name is detected and the following error message is returned:
"Analytic Server Error(1060115): Attribute Calculations dimension/member name already used."
If the outline is tagged as a duplicate member outline, and an attribute dimension (and, therefore, the attribute calculations dimension) exists before you use Sum, Count, Min, Max, and Avg as a base member, the duplicate name is allowed. However, if, you use Sum, Count, Min, Max, and Avg as a base member before creating an attribute dimension, the duplicate name isn't allowed.
The following is a list of words that are restricted and cannot be used in dimension, member, and alias names:
Table A-4 Restricted Words in Dimension, Member, and Alias Names
Restricted Word Restricted Word Restricted Word