Name and Related Artifact Limits

Names, paths, and other characteristics of Essbase data types and artifacts are subject to character and length rules specified here.

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	Limit: 1024 characters See Naming Conventions for Dimensions, Members, and Aliases for more limitations.
Alias table name	Limit: 30 characters
Application names	Limit: 30 characters The following special characters are not permitted: : ; , = + * ? [ ] |< > \ " ' / [Space] [Tab] [Ascii values <32] [Unicode characters]
Application description	Limit: 80 characters
Custom-defined function name Custom-defined macro name Custom-defined function specification Custom-defined macro specification	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	Limit: 256 characters. MaxL and the API truncate characters after 256 characters. No truncation on server. No error is displayed if truncation occurs.
Database (cube) names	Limit: 30 characters The following special characters are not permitted: : ; , = + * ? [ ] |< > \ " ' / [Space] [Tab] [Ascii values <32] [Unicode characters]
Database description	Limit: 80 characters
Dimension name	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	Limit: 1024 characters
Environment variable name	Limit: 320 characters
Environment variable value	Limit: 256 characters
Essbase Server name	Limit: 1024 characters
File names	Limit: 255 on Linux and 175 on Windows, including the file extension. The following special characters are not permitted: : ; , = + * ? [ ] |< > \ " ' / [Space] [Tab] [Ascii values <32] [Unicode characters]
Filter name	Limit: 256 characters The following special characters are not permitted: : ; , = + * ? [ ] |< > \ " ' / [Space] [Tab] [Ascii values <32] [Unicode characters]
Group name	Limit: 256 characters The following special characters are not permitted: : ; , = + * ? [ ] |< > \ " ' / [Space] [Tab] [Ascii values <32] [Unicode characters]
LRO cell note	Limit: 600 characters
LRO URL	512 characters (always single-byte characters)
LRO description for URLs and files	Limit: 80 characters
Member comment field	Limit: 256 characters
Member name	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	Limit: 20 levels
Password	Limit: 100 characters. Use of $ (dollar sign) character within the Essbase password is not supported for logins in a Linux environment.
Runtime substitution variable name	Limit: 320 bytes
Runtime substitution variable value	Limit: 256 bytes
Substitution variable name	Limit: 320 bytes See also Rules for Setting Substitution Variable Names and Values
Substitution variable value	Limit: 256 bytes See also Rules for Setting Substitution Variable Names and Values
Maximum number of text values in a text list object	32,766
Maximum length of the name of a text value	80
Trigger name	Limit: 30 characters
UDA	Limit: 1024 characters
User name	Limit: 50 characters The following special characters are not permitted: ; , = + * ? [ ] |< > \ " ' / # [Space] [Tab]