Other Size or Quantity Limits

Table 241 lists other size and quantity limits.

Table 241. Other Size or Quantity Limits

Artifact

Limits

Formula size

65534 bytes

Number of security filters

  • Per Essbase Server: 65535

  • Per Essbase database: 32290

Number of users and groups (combined)

30,000

Exceeding this limit results in an error.

Number of aggregate views within an aggregation

1023

Rules file maximum record size

64 KB

MDX maximum query limits and set sizes

See the “MDX Query Limits” topic in the Oracle Essbase Technical Reference.

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