Memory Error on Large Queries
Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase
When running large MDX queries against an aggregate storage database, you may run in to the following "out of server memory" error:
To resolve this issue, raise the limit in QUERYRESULTLIMIT in essbase.cfg
. See QUERYRESULTLIMIT in the
Technical Reference for Oracle Analytics Cloud - Essbase
for instructions on this configuration setting.
Note:
The information in QUERYRESULTLIMIT applies to both Oracle Analytics Cloud - Essbase and these Essbase versions: 11.1.2.4.008, 11.1.2.4.505, and 11.1.2.3.508_22314799.