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

Narrative Reporting: Grid Data Limit - Fusion Data Sources

Received Response
85
Views
6
Comments

Summary:

Narrative Reporting: Grid Data Limit - Fusion Data Sources

Content (required):

I'm facing this issue when trying to run a grid report (trial balance):

"Grid Data Limit The maximum number of cells that can be returned by a grid is 1,000,000 cells. If this limit is reached when previewing the grid or report, you will receive this error: Error executing query. The number of cells exceeds the maximum of 1000000."

I have investigated and it looks like the "Suppress missing blocks" option is available only for EPM Data Sources (?), however I'm using Fusion GL as my Data source....

I have tried a workaround by reducing the number of intersections (accounts/products in the row axis; Entities/ledgers in the col axis), which has kind of work for a PL report (although not future proofing the report), however for Balance Sheet, due to the large amount of entities with data, it's not possible to use this workaround.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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