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.
Table 237 lists limits for names and related artifacts.
Table 237. Names and Related Artifacts
Non-Unicode application limit: 8 bytes
Table 238 lists limits related to data loading and dimension building.
Table 238. Data Load and Dimension Build Limits
|Maximum number of generations allowed when building a duplicate member dimension||20|
Table 239 lists limits related to aggregate storage databases.
Table 239. Aggregate Storage Limits
To view dimension level factors:
Maximum number of cells that can be queried in an aggregate storage database that has a very sparse data set
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, Fusion Edition) that suppresses missing data in order to generate a relatively small report compared to the size of the query.
Number of alias tables
Table 240 lists limits related to block storage databases.
Table 240. Block Storage Database Limits
For instructions on how to calculate the number of possible blocks in a block storage database, see Potential Number of Data Blocks.
When viewing or editing Linked Reporting Objects attached to cells, you may encounter a limitation prior to 2104, 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.
Numbers of alias tables
Table 241 lists limits related to drill-through URLs.
Table 242 lists other size and quantity limits.
Table 242. Other Size or Quantity Limits
Exceeding this limit results in an error.
See the “MDX Query Limits” topic in the Oracle Essbase Technical Reference.