You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

QUERYRESULTLIMIT Error in Reports

Received Response
106
Views
9
Comments
edited Nov 10, 2023 5:18PM in Planning 9 comments

Summary:

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!