i have calculation script normally it takes 10min time to execute.
same calculation is taking now 20 min time.
can any one help me in know y it is happening like that and what measure do i need to take for reducing time.
1) Make sure that there were no outline changes that could have affected performance. Increased number of members, dynamic calc changed to stored, even someone messing with some server or db settings.
2) If you calc script has multiple steps, look at each one in the log, compare the times between the 10 min run and the 20 min run. See if they all increased, or if only one step increased.
3) Check cube fragmentation
4) Maybe there were other things running on the server at the time the calc was run (exports, or other loads/calcs) and perhaps it was a "one off"?