When naming dimensions, members, and aliases in the database outline, follow these rules:
Use no more than 80 characters when naming dimensions, members, or aliases.
Names are not case-sensitive unless case-sensitivity is enabled. See “Setting Outline Properties” in Essbase Administration Services Online Help.
Do not use quotation marks (""), brackets ([]), or tabs anywhere in a name.
At the beginning of a dimension or member name, do not use the following characters:
@ at | () parentheses |
\ back slash | . period |
{} braces | + plus |
, comma | ' apostrophe |
- dash, hyphen, or minus | _ underscore |
= equals | | vertical bar |
< less than |
Do not place spaces at the beginning or end of a name. Essbase ignores spaces at the beginning or end of a name.
Do not use the following words as dimension or member names:
Calculation script commands, operators, and keywords. For a list of commands, see the Essbase Technical Reference.
Report writer commands. For a list of commands, see the Essbase Technical Reference.
Function names and function arguments. For a list of functions, see the Essbase Technical Reference.
Names of other dimensions and members (unless the member is shared), and generation names, level names, and aliases in the database.
ALL | GENRANGE | OR |
AND | GROUP | PAREN |
ASSIGN | GT | PARENPARM |
CALC | ID | PERCENT |
CALCMBR | IDERROR | PLUS |
COPYFORWARD | INTEGER | RELOP |
CROSSDIM | LE | SET |
CURMBRNAME | LEVELRANGE | SKIPBOTH |
DIM | LOOPBLOCK | SKIPMISSING |
DIMNAME | LOOPARMS | SKIPNONE |
DIV | LT | SKIPZERO |
DYNAMIC | MBR | TO |
EMPTYPARM | MBRNAME | TOLOCALRATE |
EQ | MBRONLY | TRAILMISSING |
EQOP | MINUS | TRAILSUM |
EXCEPT | MISSING | UMINUS |
EXP | MUL | UPPER |
EXPERROR | MULOP | VARORXMBR |
FLOAT | NE | XMBRONLY |
FUNCTION | NON | $$$UNIVERSE$$$ |
GE | NONINPUT | #MISSING |
GEN | NOT | #MI |