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