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

Can you sort rows through multiple grids in a management report oracle cloud?

Received Response
13
Views
2
Comments
edited Feb 1, 2024 7:07PM in Narrative Reporting 2 comments

Hello,

I created a report that is set to bottom levels of all hierarchies within the cube. This causes query limits errors when there is a large number of blocks. The report has been optimized by turning on suppression for no data and missing blocks as well as using the ASO cube for faster run times. To mitigate the query limit issue, I decided to break down the queries into three grids. As a consequence, the sorting created in the "one Grid" report goes out the window. Is there a way to sort the report across the three grids?

There is also another issue that comes from gaps in between the grids, is there a ways to make all three grid display seamlessly?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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