Limits

This appendix contains a list of limits you may encounter when creating or manipulating Essbase objects:

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.






© 2002 Hyperion Solutions Corporation. All rights reserved.
http://www.hyperion.com