Other Size or Quantity Limits
Refer to this section for limits on size and quantity of various Essbase strings, filters, records, queries, arrays, and other artifacts.
Table A-6 Other Size or Quantity Limits
| Artifact | Limits |
|---|---|
|
Formula size |
65534 bytes |
|
Number of security filters |
|
|
Number of users and groups (combined) |
30,000 Exceeding this limit results in an error. |
|
Rules file maximum record size |
64 KB |
|
Rules file SQL query maximum size |
64 KB |
|
MDX maximum query limits and set sizes |
See MDX Query Limits. |
|
Report Writer maximum query limits and set sizes |
See the Report Writer Limits topic. |
|
Maximum size for variable arrays in calculation scripts and formulas. Arrays temporarily store arguments to calculation functions, including MEMBERS, NUMBERS, and STRINGS, or values associated with them. |
Maximum integer value of 2,147,483,647 |
|
MaxL maximum statement length |
81,920 characters or bytes |
|
Maximum length of a format string |
256 characters |
|
Maximum number of data audit records you can view in the Essbase web interface and in Smart View. |
5000. More records can be fetched using the REST API. Refer to Get Audit Data. |