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

groovy failing with datagriddefinationbuilder

in Planning 5 comments

Hi Team

one of our Groovy BR (due to huge volumes) is failing execution with below error. Any suggestions / alternative ways?

A method called by the script failed on line: 41, with error: Unable to load the form as the number of cells before suppression (if form suppression options are selected) exceeded the threshold. Criteria: Number of cells before suppression, Error Threshold: 2000000, Current Value: 2825172

Code

DataGridDefinitionBuilder sourceBuilderCLC = sourceCubeCLC.dataGridDefinitionBuilder()
sourceBuilderCLC.setSuppressMissingBlocks(true)
sourceBuilderCLC.setSuppressMissingRows(true)
sourceBuilderCLC.setSuppressInvalidRows(true)
sourceBuilderCLC.addPov(['Future1', 'Future2','Source','Employee','Scenario','Version','Years','Currency'],
[ ['No Future1'], ['No Future2'],['Total Source'],['Total Employee'],[cscParams(Scenario)],[cscParams(Version)],[cscParams(Year)],['Local_LegalEntity']])

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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