Calculation Scripts performance issue.
SummaryCalculation Scripts performance issue.
I'm facing calculation scripts performance in one of many environment where execution time of all clac scripts has been increased 2-3 times then what it used to in past.
I have performed dense/force restructure on cube. After restructure there was a decrease of 478181 in number of existing blocks and Avg Clustering Ratio also decreased from 1 to 0. After restructure performance was improved(one calc script execution time decreased from 30 minutes to 18 minutes). But again after weekly/monthly load job execution number of existing blocks again increased and calc scripts are still under performing.
What could be the possible reason/solution of performance issue in calc scripts.