Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 script error query threshold limit

edited May 16, 2024 7:33AM in EPM Platform and Freeform 1 comment

Summary:

Hi experts,

I have written a groovy rule using flexibleDataGrid to export the dynamic calc Parent members plus all stored sparse members to a csv file . while executing got an error query threshold limit , please check the essbase.cfg . Below is the groovy code, what is the best way to export all stored members plus the dynamic calc using loop or hashmap or another other method

Our Cube size more than 10 GB

Cube cube = operation.application.getCube("xxxxx")
def dataGrid = cube.flexibleDataGridDefinitionBuilder()
dataGrid.setPovDimensions('Scenario', 'Version')
dataGrid.setPov('Actual', 'Working')

dataGrid.addColumn('&StYr','ILvl0Descendants(YearTotal)')dataGrid.addRow('IDescendants(AxXXSeries)','IDescendants(C100)','IDescendants(E_10)','IDescendants(T_ops)','IDescendants(Total_CostCenter)','IDescendants(OFS_Total Plan)')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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