Limits

In This Section:

In this appendix, the term non-Unicode applications refers to non-Unicode-mode applications and applications on Essbase Servers that are not Unicode-enabled. See Understanding the Essbase Unicode Implementation.

Name and Related Artifact Limits

Table 236 lists limits for names and related artifacts.

Table 236. Names and Related Artifacts

Artifact	Limits
Alias name	Non-Unicode application limit: 80 bytes Unicode-mode application limit: 80 characters
Alias table name	Non-Unicode application limit: 30 bytes Unicode-mode application limit: 30 characters
Application name	Non-Unicode application limit: 8 bytes Unicode-mode application limit: 30 characters
Application description	Non-Unicode application limit: 79 bytes Unicode-mode application limit: 80 characters
Custom-defined function name Custom-defined macro name Custom-defined function specification Custom-defined macro specification	Non-Unicode application limit: 127 bytes. MaxL and the API truncate characters after 127 bytes. Unicode-mode application limit: 128 characters. MaxL and the API truncate characters after 128 characters. In either case, no truncation on server. No error is displayed if truncation occurs.
Custom-defined function and macro comment	Non-Unicode application limit: 255 bytes. MaxL and the API truncate characters after 255 bytes. Unicode-mode application limit: 256 characters. MaxL and the API truncate characters after 256 characters. In either case, no truncation on server. No error is displayed if truncation occurs.
Database name	Non-Unicode application limit: 8 bytes Unicode-mode application limit: 30 characters
Database description	Non-Unicode application limit: 79 bytes Unicode-mode application limit: 80 characters
Directory path For example: EPM_ORACLE_HOME/products/Essbase/EssbaseServer/bin	Non-Unicode application limit: 255 characters Unicode-mode application limit: 1024 characters
Environment variable name	Non-Unicode application limit: 320 bytes Unicode-mode application limit: 320 characters
Environment variable value	Non-Unicode application limit: 256 bytes Unicode-mode application limit: 256 characters
Essbase Server name	Non-Unicode application limit: 1024 bytes Unicode-mode application limit: 1024 characters
Filename for calculation scripts, report scripts, and rules files	Non-Unicode application limit: 8 bytes Unicode-mode application limit: If included within a path, the smaller of the following two values: 1024 bytes The limit established by the operating system If not included within a path, as in some MaxL statements, 1024 bytes.
Filename for text and Excel files	Non-Unicode application limit: 8 bytes
Filter name	Non-Unicode application limit: 256 bytes Unicode-mode application limit: 256 characters
Group name	Non-Unicode application limit: 256 bytes Unicode-mode application limit: 256 characters
LRO cell note	Non-Unicode application limit: 600 bytes Unicode-mode application limit: 600 characters
LRO URL	512 characters (always single-byte characters)
LRO description for URLs and files	Non-Unicode application limit: 80 bytes Unicode-mode application limit: 80 characters
Member comment field	Non-Unicode application limit: 255 bytes Unicode-mode application limit: 256 characters
Member name	Non-Unicode application limit: 80 bytes Unicode-mode application limit: 80 characters
Qualified member name limit: the number of levels that can be specified in a qualified member name	20 levels
Password	Non-Unicode application limit: 100 bytes Unicode-mode application limit: 100 characters
Runtime substitution variable name	320 bytes
Runtime substitution variable value	256 bytes
Substitution variable name	320 bytes
Substitution variable value	256 bytes
Maximum number of text values in a text list object	1024
Maximum length of the name of a text value	80
Range of numbers for the ID of a text value	-32768 to 32767
Trigger name	Non-Unicode application limit: 30 bytes Unicode-mode application limit: 30 characters
UDA	Non-Unicode application limit: 80 bytes Unicode-mode application limit: 80 characters
User name	Non-Unicode application limit: 256 bytes Unicode-mode application limit: 256 characters

Data Load and Dimension Build Limits

Table 237 lists limits related to data loading and dimension building.

Table 237. Data Load and Dimension Build Limits

Artifact	Limits
Selection and rejection criteria	Number of characters that describe selection and rejection criteria: combination of all criteria limited to 32 KB
Number of error messages written to a data load or dimension build error log (DATAERRORLIMIT in essbase.cfg)	Default 1000, minimum 1, maximum 65000
Maximum number of generations allowed when building a duplicate member dimension	20
Maximum number of source files for incremental dimension build	64

Aggregate Storage Database Limits

Table 238 lists limits related to aggregate storage databases.

Table 238. Aggregate Storage Limits

Artifact	Limits
Number of hierarchies in a single dimension of an aggregate storage database	65535 (including all stored hierarchies, dynamic hierarchies, and any attribute dimensions based on the dimension)
Number of members in an aggregate storage outline	10,000,000 to 20,000,000 members, depending on available memory and other memory requirements
Maximum file location size in an aggregate storage database	4,294,967,295 MB
Number of stored dimension level combinations in an aggregate storage outline	The product of dimension level factors across stored dimensions cannot exceed 2⁵², which is equal to 4,503,599,627,370,496. To calculate the number of stored dimension levels in an outline: Determine the stored-level factor for each dimension. Multiply the dimension factors together; for example, a * b * c * d, and so on. To determine the factor for each dimension, use the following guidelines: For dynamic dimensions, the factor is 1. For stored dimensions, for an initial dimension factor, count the nonlabel-only levels. If a stored dimension has attribute dimensions, count the levels in each attribute dimension, and add that number to the dimension factor. Then, if all level 0 members of the dimension have an attribute from a specific attribute dimension, subtract 1 for each attribute dimension in which this occurs. If a stored dimension has additional stored hierarchies, count the number of nonlabel-only levels in each stored hierarchy, and add the count to the dimension factor. Do not count a level if it comprises only shared members. Dynamic hierarchies in a stored dimension do not affect the dimension factor. For example, multiplying the factors for the 11 dimensions in ASOsamp.Sample, 1 * 1 * 4 * 2 * 2 * 2 * 3 * 2 * 6 * 7 * 7 equals 56,448. To view dimension level factors: In Administration Services Console, right-click a database, select Edit, and then Properties. On the Statistics tab, under Aggregate storage statistics, each non-attribute dimension in the outline is listed, showing the number of stored levels (which is the dimension level factor) in each dimension. For example: Dimension [Products] has [6] levels, bits used 7 Use this MaxL command: query database appName.dbName list aggregate_storage runtime_info;
Maximum number of cells that can be queried in an aggregate storage database that has a very sparse data set	2⁶⁴ The limit is based on the number of cells that Essbase processes in the query, which is the product of the member count across all dimensions, not on the number of cells contained in the output report. You might encounter this limit when using a client interface (such as Oracle Hyperion Financial Reporting) that suppresses missing data in order to generate a relatively small report compared to the size of the query.
Number of alias tables	32
Number of parallel export threads	8 For information about how Essbase uses export threads, see the data export MaxL command for block storage database and the EXPORTTHREADS configuration setting in the Oracle Essbase Technical Reference.

Block Storage Database Limits

Table 239 lists limits related to block storage databases.

Table 239. Block Storage Database Limits

Artifact	Limits
Number of members in a block storage outline	Approximately 1,000,000 explicitly defined members in an Essbase outline. Hybrid Analysis and some uses of partitions enable access to many more members than those that are explicitly listed in an outline; the actual number of members accessible through the database is much greater. Longer member names, which can occur if using multibyte characters, decrease the number of members that are allowed.
Number of non-zero values in a dense data block in a block storage database	32-bit and 64-bit: 2²⁸ -1 (268,435,455)
Number of possible sparse blocks in a block storage database	The product of the stored member count of sparse dimensions cannot exceed the following values: 32-bit: 2¹⁰⁴ 64-bit: 2¹²⁸ For instructions on how to calculate the number of possible sparse blocks in a block storage database, see Potential Number of Data Blocks.
Number of possible cells per block in a block storage outline (cell limit when saving an outline)	32-bit and 64-bit: 2⁵²
Number of Linked Reporting Objects in a block storage database	32-bit and 64-bit: 2¹⁰⁴ Note: When viewing or editing Linked Reporting Objects attached to cells, you may encounter a limitation prior to 2¹⁰⁴, if the outline has non-stored members. If this occurs, the following error is displayed: "Error 1140013 Invalid Cell Address Entered" You can work around the limit by reordering the dimensions in the outline.
Number of alias tables	32
Number of parallel export threads	1024 For information about how Essbase uses export threads, see the data export MaxL command for aggregate storage database and the EXPORTTHREADS configuration setting in the Oracle Essbase Technical Reference.

Drill-through to Oracle Applications Limits

Table 240 lists limits related to drill-through URLs.

Table 240. Drill-through to Oracle Applications Limits

Artifact	Limits
Number of drill-through URLs per database	255
Number of drillable regions in a drill-through URL	256
Number of characters per drillable region	65536

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