Name and Related Artifact Limits

The following table lists limits for names and related artifacts.

Release Essbase 19c and later supports Unicode applications only.

Table A-1 Names and Related Artifacts

Artifact	Limits
Alias name	Unicode-mode application limit: 1024 characters See Naming Conventions for Dimensions, Members, and Aliases for more limitations.
Alias table name	Unicode-mode application limit: 30 characters
Application name	Unicode-mode application limit: 30 characters
Application description	Unicode-mode application limit: 80 characters
Custom-defined function name Custom-defined macro name Custom-defined function specification Custom-defined macro specification	Unicode-mode application limit: 128 characters. MaxL and the API truncate characters after 128 characters. No truncation on server. No error is displayed if truncation occurs.
Custom-defined function and macro comment	Unicode-mode application limit: 256 characters. MaxL and the API truncate characters after 256 characters. No truncation on server. No error is displayed if truncation occurs.
Database name	Unicode-mode application limit: 30 characters Non-Unicode application limit: 8 bytes Unicode-mode application limit: 30 characters
Database description	Unicode-mode application limit: 80 characters Non-Unicode application limit: 79 bytes Unicode-mode application limit: 80 characters
Dimension name	Unicode-mode application limit: 1024 characters Non-Unicode application limit: 1024 bytes Unicode-mode application limit: 1024 characters See Naming Conventions for Dimensions, Members, and Aliases for more limitations.
Directory path For example: /scratch/user/essbase/oracle_home/oracle_common/bin	Unicode-mode application limit: 1024 characters
Environment variable name	Unicode-mode application limit: 320 characters
Environment variable value	Unicode-mode application limit: 256 characters
Essbase Server name	Unicode-mode application limit: 1024 characters
Filename for calculation scripts, report scripts, and rules files	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	Unicode-mode application limit: 256 characters The following special characters are not permitted: ! @ # $ % ^ & * () _ + - = {} [] | ; ' : " < > ? , . / ~ `
Group name	Unicode-mode application limit: 256 characters The following special characters are not permitted: . ; , = + * ? [ ] |< > \ " ' / [Space] [Tab]
LRO cell note	Unicode-mode application limit: 600 characters
LRO URL	512 characters (always single-byte characters)
LRO description for URLs and files	Unicode-mode application limit: 80 characters
Member comment field	Unicode-mode application limit: 256 characters
Member name	Unicode-mode application limit: 1024 characters See Naming Conventions for Dimensions, Members, and Aliases for more limitations.
Qualified member name limit: the number of levels that can be specified in a qualified member name	20 levels
Password	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	Unicode-mode application limit: 30 characters
UDA	Unicode-mode application limit: 1024 characters
User name	Unicode-mode application limit: 256 characters The following special characters are not permitted: ; , = + * ? [ ] |< > \ " ' / [Space] [Tab]