Restrictions for Dimensions, Members, Aliases, and Forms
When naming dimensions, members, and aliases, follow these rules:
-
For dimensions, members, or aliases, use no more than 80 characters.
Note:
- For Entity members, names cannot exceed 76 characters in length.
- For all dimensions, do not use commas in member names.
-
Do not use HTML tags in member names, dimension names, aliases, and descriptions.
-
The following is a list of characters that are restricted and cannot be used in dimension, member, and alias names:
Table 5-1 Restricted Characters in Dimension, Member, and Alias Names
Character Meaning "
quotation mark
[ ]
bracket
\
backslash
/
slash
Note:
-
Brackets [ ] are permitted but not recommended in block storage outlines. They cause errors when converting to aggregate storage outlines.
-
Do not use the ASCII substitute character (zero-width space character)
0x1A
in member names and aliases.
-
-
The following is a list of characters that cannot be used at the beginning of dimension, member, and alias names:
Table 5-2 Restricted Characters at the Beginning of Dimension, Member, and Alias Names
Character Meaning @
at sign
&
ampersand
\
backslash
[ ]
brackets
,
comma
-
dash, hyphen, or minus sign
=
equal sign
<
less than sign
( )
parentheses
.
period
+
plus sign
"
quotation mark
/
slash
_
underscore
|
vertical bar
Note:
Member names with the preceding characters are not allowed in business process data export jobs.
-
Do not place spaces at the beginning or end of names. Such spaces are ignored.
-
Do not use forward slashes in member names.
-
For time periods in custom calendars, do not use spaces in prefixes.
-
Do not use these words as dimension or member names:
-
Calculation script commands, operators, and keywords.
-
Do not prefix an object name with any of the following: OEP_, OFS_, OCX_, OWP_, OPF_, FCCS_, TRCS_, ARCS_, OQP_, OGS_. For example, the prefix "TRCS_A" is invalid. However, you can use the acronyms within the object name, for example, A_TRCS, BTRCS, or TRCSB.
-
Function names and function arguments.
-
Names of other dimensions and members (unless the member is shared).
-
If Dynamic Time Series is enabled, do not use History, Year, Season, Period, Quarter, Month, Week, or Day.
-
- The following is a list of words that are restricted and cannot be used in
dimension, member, and alias names:
Table 5-3 Restricted Words in Dimension, Member, and Alias Names
Restricted Word Restricted Word Restricted Word ALL AND ASSIGN AVERAGE CALC CALCMBR COPYFORWARD CROSSDIM CURMBRNAME DIM DIMNAME DIV DYNAMIC
EMPTYPARM
EQ
EQOP
EXCEPT
EXP
EXPERROR
FLOAT
FUNCTION
GE GEN
GENRANGE
GROUP
GT
ID
IDERROR
INTEGER
LE
LEVELRANGE
LOCAL
LOOPBLOCK
LOOPPARMS
LT MBR
MBRNAME
MBRONLY
MINUS
MISSING
MUL
MULOP
NE
NON
NONINPUT
NOT
OR
PAREN
PARENPARM
PERCENT
PLUS
RELOP
SET
SKIPBOTH
SKIPMISSING
SKIPNONE
SKIPZERO
STATUS TO
TOLOCALRATE
TOP
TRAILMISSING
TRAILSUM
TYPE
UMINUS
UPPER
VARORXMBR
XMBRONLY
$$UNIVERSE$$
#MISSING
#MI