In This Section:
Use no more than 30 characters when naming Unicode-mode applications and databases.
Do not use the characters listed in Table 254 in the name:
For database names, do not use the:
String drxxxxxx (not case-sensitive)
Reserved word Replay
DEFAULT LOG METADATA REPLAY TEMP
Application and database names are not case-sensitive. However, on case-sensitive file systems, the application or database name is created exactly as you enter it. Therefore, when creating, renaming, or copying applications and databases on case-sensitive file systems, Essbase ensures that the same application or database name but with different case usage cannot be used. For example, if you create an application name with all uppercase letters (NEWAPP), you cannot then create an application with the same name but with mixed-case letters (Newapp). Also, when manually copying application and database files from one computer to another and then creating an application or database, you must use the same case for the application and database directory names on both computers.
Use no more than 80 characters when naming Unicode-mode dimensions, members, or aliases.
See “Setting Outline Properties” in the Oracle Essbase Administration Services Online Help.
Even when case-sensitivity is enabled, in an aggregate storage outline for which duplicate member names is enabled, do not use matching names with only case differences for a dimension name. For example, do not name two dimensions “Product” and “product.”
At the beginning of dimension or member names, do not use the characters listed in Table 255:
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 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 TO TOLOCALRATE TRAILMISSING TRAILSUM UMINUS UPPER VARORXMBR XMBRONLY $$$UNIVERSE$$$ #MISSING #MI
If you enable Dynamic Time Series members, do not use the following associated generation names:
In unique member outlines that contain an attribute dimension (and, therefore, an Attribute Calculations dimension), do not use the following names unless you change the default names in the Attribute Calculations dimension:
If the outline is tagged as a duplicate member outline, you can use the default names to name other base or attribute members.
In substitution variable values, environment variable values, calculation scripts, report scripts, filter definitions, partition definitions, or formulas, you must enclose member names in brackets ([ ]) when used within MDX statements, and otherwise in quotation marks (" "), in these situations:
Name contains spaces or any characters listed in Table 256:
In calculation scripts and formulas, you must enclose these member names, which are also Essbase keywords, in quotation marks (" ") for block storage databases, and in brackets ([ ]) for aggregate storage databases:
BEGIN DOUBLE ELSE END FUNCTION GLOBAL IF MACRO MEMBER RANGE RETURN STRING THEN
When using attribute dimensions, Essbase creates the following dimension and members names:
Member names in attribute dimensions:
Dimension name: Attribute Calculations
Member names in the Attribute Calculations dimension: