Fluctuacion on calc execution times
Hi everyone,
We have a pretty simple BR to erase data. It goes like this:
Fix({MEX_CurrPer},{MEX_YearAct},@idescendants("Net Profit"),"Actual1", "Actual2", "Actual3")
Cleardata "Working";
Endfix
The Entity dimension as well as several custom dimensions are not included in the FIX because we want all data on them to be erased.
The rule essentially works and it usually needs less than 20 minutes to finish —mind you, 20 min is still a lot for a simple Cleardata, but this is a huge cube— but from time to time it takes the rule about 1h to complete, as you can see in the image below:
Tagged:
0