Restrictions for Dimensions, Members, Aliases, and Forms
When naming dimensions, members, and aliases, follow these rules:
-
For non-Unicode mode dimensions, members, or aliases, use no more than 80 bytes. For Unicode-mode dimensions, members, or aliases, use no more than 80 characters.
-
Do not use HTML tags in member names, dimension names, aliases, and descriptions.
-
Do not use quotation marks, brackets, backslashes, or tabs. Brackets are permitted but not recommended in block storage outlines. They cause errors when converting to aggregate storage outlines.
-
To begin dimension or member names, do not use these characters:
-
at signs
-
backslashes
-
brackets
-
commas
-
dashes, hyphens, or minus signs
-
equal signs
-
less than signs
-
parentheses
-
periods
-
plus signs
-
quotation marks
-
underscores
-
vertical bars
-
-
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.
For a list of commands, see the Oracle Essbase product documentation.
-
Report Writer commands; see the Oracle Essbase Technical Reference.
-
Function names and function arguments.
-
Names of other dimensions and members (unless the member is shared), and generation names, level names, and aliases in the database.
-
If Dynamic Time Series is enabled, do not use History, Year, Season, Period, Quarter, Month, Week, or Day.
-
These words:
-
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
-
TRAILMISSING
-
TRAILSUM
-
TYPE
-
UMINUS
-
UPPER
-
VARORXMBR
-
XMBRONLY
-
$$UNIVERSE$$
-
#MISSING
-
#MI
-
-