Methods to Increase the performance and reduce the run time of the calculation scripts. — Cloud Customer Connect
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

Methods to Increase the performance and reduce the run time of the calculation scripts.

edited Jun 27, 2020 8:17AM in Planning 5 comments

Content

Please provide Common ways of optimizing the calculation scripts:

1.Here we have 12 dimensions in my financial application in which 3 dimension contains more than 1500 members that too with the flat hierarchy.

2.Dim1 with 1500 members under one parent similarly for other too dimension with 1500 members under one parent.

 Whenever i try to write a calculation around these three dimension its taking 15-20 minutes to execute a script(it has to pass through all the members as the dimensions are flat hierarchy)

3.Kindly let us know how to reduce the run time and increase the performance.

4.Please provide your inputs with common ways of optimizing the calculation script.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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