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

in Narrative Reporting 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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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