QUERYRESULTLIMIT Error in Reports
Need to update the limit or find work around on report
Content (please ensure you mask any confidential information):
I am trying to create a report that shows specific costs by vendor and company. I have it set to suppress all zeros and missing data. However, when I try to include the base level department, I get the following error:
"The number of query result cells exceeds the limit set by the QUERYRESULTLIMIT Essbase configuration setting. You need to increase this limit or simplify the report."
When I run this in an ad hoc, with the base level departments, it has about 900 rows of data. Columns are 2023 and 2024 by quarter, so not too many rows across. The number of accounts is 7, and companies is 5. Not all of them have data in each account/vendor, etc. I definitely have seen larger reports, so I'm not sure what I'm missing.