Table 92: Objects and Limits
Object |
Description of Limit |
Names and Related Fields |
Alias name
|
80 bytes
|
Alias table
|
30 bytes
|
Application name
|
8 bytes
|
Application description
|
79 bytes
|
Custom-defined function name Custom-defined macro name
|
127 bytes. After 127 bytes, characters truncated by MaxL and API. No truncation on server. No error occurs.
|
Custom-defined function and macro specification
|
127 bytes. After 127 bytes, characters truncated by MaxL and API. No truncation on server. No error occurs.
|
Custom-defined function and macro comment
|
255 bytes. After 127 bytes, characters truncated. by MaxL and API. No truncation on server. No error occurs.
|
Database name
|
8 bytes
|
Database description
|
79 bytes
|
Directory path
|
255 bytes. For example: /essbase/bin
|
Filter name
|
30 bytes
|
Group name
|
30 bytes
|
Linked reporting object cell note
|
599 bytes
|
Linked reporting object URL
|
512 characters (always single-byte characters)
|
Member comment field
|
255 bytes
|
Member comment field (extended)
|
8192 bytes
|
Member name
|
30 characters
|
OLAP Server name
|
30 bytes
|
Password
|
101 bytes. After 100 single-byte characters or 50 double-byte characters, Essbase will not let the user log in and reports an error.
|
Substitution variable name
|
80 bytes
|
Substitution variable value
|
255 bytes
|
User names
|
30 bytes
|
Variable names
|
32 bytes
|
Data Load and Dimension Building Limits |
Selection and rejection criteria
|
Number of characters that describe selection and rejection criteria: combination of all criteria limited to 32 KB
|
essbase.cfg-Releated Limits |
AUTHENTICATIONMODULE
|
256 byte limit: parameter default_connection_parameter
|
Other Limits |
Caches: data, data file, index
|
2 GB
|
DATAERRORLIMIT, number of error messages written to a log.
|
Default 1000, minimum 1, maximum 65000
|
Formula size
|
- Limited to 64 KB if created with Formula Editor. Formulas in calculation scripts are not subject to this limit.
- Formulas created in MaxL, using multi-byte characters, are limited to 40 KB.
|
Number of security filters
|
Per OLAP Server, 32767
Per Essbase database, 32290
|
Number of users
|
30,000. Errors may occur if you create more than 30,000 users.
|
Number of members in an outline
|
1,000,000 explicitly defined in an Essbase outline. Because Hybrid Analysis and some uses of partitions can involve many more members than are explicitly listed in an outline, the actual number of members accessible through the database is much higher.
|