Essbase Character and Word Limitations
The following is a comprehensive list of character and word limitations that apply to Oracle Essbase. All of the limitations apply to all of the Oracle General Ledger configurations summarized in the table.
The following table shows how the General Ledger configuration maps to Essbase.
|
General Ledger Configuration |
Maps to Essbase |
|---|---|
|
Chart of Account Name |
Cube Name |
|
Chart of Account Segment Name |
Dimension Name |
|
Chart of Accounts Segment Value |
Dimension Member Name |
|
Chart of Accounts Segment Value Description |
Alias for Member |
|
Tree and Tree Version Name |
Dimension Member Name |
|
Primary Ledger Name |
Dimension Member Name in Ledger Dimension |
|
Secondary Ledger Name |
Dimension Member Name in Ledger Dimension |
|
Reporting Currency |
Dimension Member Name in Ledger Dimension |
|
Ledger Set Name |
Dimension Member Name in Ledger Dimension |
|
Accounting Calendar Period Names |
Dimension Member Name in Accounting Period Name |
|
Scenario Name Defined in Predefined Value Set Called Accounting Scenario |
Dimension Member Name in Scenario Dimension |
Even if case sensitivity is enabled in an aggregate storage outline for which duplicate member names is enabled, don't use matching dimension names with only case differences. For example, don't:
-
Name two dimensions Product and product.
-
Use quotation marks or brackets.
-
Use tabs in dimension, member, or alias names.
-
Use accent characters.
-
Use the characters for dimension or member names.
Restricted Characters
The following table lists the characters that are restricted and can’t be used at the beginning of cube, dimension, member, or alias names.
| Character | Meaning |
|---|---|
| - | dash, hyphen, or minus sign |
| _ | underscore |
The following table lists the characters that are restricted and can’t be used in cube, dimension, member, or alias names.
|
Character |
Meaning |
|---|---|
|
& |
ampersand Note: Aliases can include ampersands as long as the ampersand
isn’t the beginning character.
|
|
@ |
at sign |
|
\ |
backslash Note: Aliases can include backslashes as long as the backslash
isn’t the beginning character.
|
|
{} |
brace |
|
, |
comma Note: Aliases can include commas as long as the comma isn’t the
beginning character.
|
|
" |
double quotation mark |
|
= |
equal sign |
|
< |
less than sign |
|
() |
parentheses Note: Member names and aliases can include parentheses as long
as a parenthesis isn’t the beginning character.
|
|
. |
period Note: Aliases can include periods as long as the period isn’t
the beginning character.
|
|
+ |
plus sign |
|
' |
single quotation mark |
|
/ |
slash Note: Aliases can include slashes as long as the slash isn’t the
beginning character.
|
|
| |
vertical bar |
Other Restrictions
-
Don't place spaces at the beginning or end of names. Essbase ignores such spaces.
-
Don't use the following types of words as dimension or member names:
-
Calculation script commands, operators, and keywords.
-
Report writer commands.
-
Function names and function arguments.
-
Names of other dimensions and members (unless the member is shared).
-
Generation names, level names, and aliases in the database.
-
The following table lists additional words that can’t be used as the entire value for a cube, dimension, member, or alias. For example, you can’t use ALL or All for an alias. However, you can use All expenses as an alias.
|
List 1 |
List 2 |
List 3 |
|---|---|---|
|
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, #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 |
|
XMRONLY |
$$$UNIVERSE$$$ |
#MI |
The following table lists General Ledger Essbase keywords that are also restricted and can’t be used as the entire value for a cube, dimension, member, or alias. For example, you can’t use ACTUAL or Actual for an alias. However, you can use Actual expenses as an alias.
| First Letter of Keyword | Keywords |
|---|---|
| A | ACTUAL, ADP, AED, AFA, AFN, ALLOCATED, AMD, ANG, AOA, AOK, AON, ARA, ARS, ATS, AUD, AWG, AZM, AZN |
| B | BAM, BASE, BBD, BDT, BEF, BEGINNINGBALANCECR, BEGINNINGBALANCEDR, BGL, BGN, BHD, BIF, BMD, BND, BOB, BOV, BRC, BRL, BSD, BTN, BUK, BWP, BYB, BYN, BYR, BZD |
| C | CAD, CD, CDF, CHE, CHF, CHW, CLF, CLP, CNY, CONVERTED, COP, COU, CRC, CSD, CSK, CUP, CVE, CYP, CZK |
| D | DAILY ACTIVITY, DAY, DEM, DJF, DKK, DOP, DZD |
| E | ECS, ECV, EEK, EGP, ENDINGBALANCECR, ENDINGBALANCEDR, ENTERED, EOD, ERN, ESB, ESP, ETB, EUR |
| F | FIM, FJD, FKP, FRF |
| G | GBP, GEK, GEL, GHC, GHS, GIP, GMD, GNF, GRD, GTQ, GWP, GYD |
| H | HISTORY, HKD, HNL, HRD, HRK, HTG, HUF |
| I | IDR, IEP, ILS, INR, IQD, IRR, ISK, ITL |
| J | JMD, JOD, JPY |
| K | KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT |
| L | LAK, LBP, LKR, LRD, LSL, LTL, LUC, LUF, LUL, LVL, LVR, LYD |
| M | MAD, MDL, MGA, MGF, MKD, MMK, MNT, MONTH, MOP, MRO, MRU, MS25, MS26, MTL, MUR, MVR, MWK, MXN, MXP, MXV, MYR, MZM, MZN |
| N | N/A, NAD, NGN, NIC, NIO, NLG, NOK, NPR, NZD |
| O | OMR |
| P | PAB, PATD, PEI, PEN, PERIOD, PERIODACTIVITYCR, PERIODACTIVITYDR, PGK, PHP, PKR, PLN, PLZ, PTA, PTD, PTE, PYG |
| Q | QAR, QATD, QTD, QUARTER |
| R | RMB, ROL, RON, RSD, RUB, RUR, RWF |
| S | SAR, SBD, SCR, SDD, SDG, SDP, SEASON, SEK, SGD, SHP, SIT, SKK, SLL, SOS, SRD, SRG, SSP, STAT, STD, STN, SUR, SVC, SYP, SZL |
| T | THB, TJR, TJS, TMM, TMT, TND, TOP, TOTAL, TOTALFORALLOCATIONS, TPE, TRL, TRY, TTD, TWD, TZS |
| U | UAH, UAK, UF, UGS, UGX, UKS, USD, USN, USS, UYI, UYP, UYU, UYW, UZS |
| V | VEB, VEF, VES, VND, VUV |
| W | WEEK, WST |
| X | XAF, XAG, XAU, XB5, XBA, XBB, XBC, XBD XCD, XDR, XEU, XFO, XFU, XGL1, XOF, XPD, XPF, XPO, XPT, XTS, XXX |
| Y | YATD, YDD, YEAR, YER, YTD, YUD, YUM, YUN |
| Z | ZAL, ZAR, ZBIQA_C1, ZBIQA_C2, ZBIQA_C3 ZBIQA_C4, ZMK, ZMW, ZRN, ZRZ, ZWD, ZWL, ZWR |