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 limit in webform is before or after suppression

Received Response
74
Views
6
Comments
edited Nov 6, 2023 12:25PM in Planning 6 comments

Summary:

I'm getting query result limit error while opening a webform for which there is no data exists. The form is having all suppressions enabled and I did permutations and combinations of suppression settings.

When I logged SR with Oracle, they retrieve backend logs and saying me that I should consider re-designing the form as the query result is exceeding the limit but there is no data for the intersections I have retrieved. And interestingly when I remove one particular combination this error is not coming up. And there is no data for that intersection too.

null. com.hyperion.planning.olap.EssbaseException: Number of query result cells exceeds the limit [5000000] set by the QUERYRESULTLIMIT configuration setting (1200766)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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