Name and Related Artifact Limits

Table A-1 lists limits for names and related artifacts.

Oracle Analytics Cloud - Essbase supports Unicode applications only.

Table A-1 Names and Related Artifacts

Artifact Limits

Alias name

  • Non-Unicode application limit: 1024 bytes

  • Unicode-mode application limit: 1024 characters

Alias table name

  • Non-Unicode application limit: 30 bytes

  • Unicode-mode application limit: 30 characters

Application name

  • Non-Unicode application limit: 8 bytes

  • Unicode-mode application limit: 30 characters

Application description

  • Non-Unicode application limit: 79 bytes

  • Unicode-mode application limit: 80 characters

Database name

  • Non-Unicode application limit: 8 bytes

  • Unicode-mode application limit: 30 characters

Database description

  • Non-Unicode application limit: 79 bytes

  • Unicode-mode application limit: 80 characters

Dimension name

  • Non-Unicode application limit: 1024 bytes

  • Unicode-mode application limit: 1024 characters

Directory path

For example:

EPM_ORACLE_HOME/products/Essbase/EssbaseServer/bin
  • Non-Unicode application limit: 255 characters

  • Unicode-mode application limit: 1024 characters

Environment variable name

  • Non-Unicode application limit: 320 bytes

  • Unicode-mode application limit: 320 characters

Environment variable value

  • Non-Unicode application limit: 256 bytes

  • Unicode-mode application limit: 256 characters

Essbase Server name

  • Non-Unicode application limit: 1024 bytes

  • Unicode-mode application limit: 1024 characters

Filename for calculation scripts, report scripts, and rules files

  • Non-Unicode application limit: 8 bytes

  • Unicode-mode application limit:

    • If included within a path, the smaller of the following two values:

      • 1024 bytes

      • The limit established by the operating system

    • If not included within a path, as in some MaxL statements, 1024 bytes.

Filename for text and Excel files

Non-Unicode application limit: 8 bytes

Filter name

  • Non-Unicode application limit: 256 bytes

  • Unicode-mode application limit: 256 characters

Group name

  • Non-Unicode application limit: 256 bytes

  • Unicode-mode application limit: 256 characters

LRO cell note

  • Non-Unicode application limit: 600 bytes

  • Unicode-mode application limit: 600 characters

LRO URL

512 characters (always single-byte characters)

LRO description for URLs and files

  • Non-Unicode application limit: 80 bytes

  • Unicode-mode application limit: 80 characters

Member comment field

  • Non-Unicode application limit: 255 bytes

  • Unicode-mode application limit: 256 characters

Member name

  • Non-Unicode application limit: 1024 bytes

  • Unicode-mode application limit: 1024 characters

Qualified member name limit: the number of levels that can be specified in a qualified member name

20 levels

Password

  • Non-Unicode application limit: 100 bytes

  • Unicode-mode application limit: 100 characters

Runtime substitution variable name

320 bytes

Runtime substitution variable value

256 bytes

Substitution variable name

320 bytes

Substitution variable value

256 bytes

Maximum number of text values in a text list object

32,766

Maximum length of the name of a text value

80

Trigger name

  • Non-Unicode application limit: 30 bytes

  • Unicode-mode application limit: 30 characters

UDA

  • Non-Unicode application limit: 1024 bytes

  • Unicode-mode application limit: 1024 characters

User name

  • Non-Unicode application limit: 256 bytes

  • Unicode-mode application limit: 256 characters