Batch of calc scripts taking three times more time to complete
Summary
Batch of calc scripts taking three times more time to completeContent
We have a unix script which calls the corresponding Maxl which in turn executes a series of Essbase Calc scripts. The whole process used to take 20 minutes or so and now(past 2-3 weeks) all of a sudden its taking 60 minutes. The data has increased slightly - not much as with the same set of data the whole sequence only takes 20 minutes in our UAT instance.
Since the scripts,metadata has been the same - i believe it has to be with the Essbase properties that is causing the delay. The number of Upper Level blocks have increased drastically - Tried restructuring the outline and clearing Upper Level Blocks which helped a bit but not much. Since this may not have a cookie cutter approach - just want to know from the Gurus where should i start looking and what kind of changes should i be looking to perform. Have tried replacing '0' with '#Missing' too.