We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Batch of calc scripts taking three times more time to complete

Received Response
19
Views
5
Comments
edited Aug 2, 2018 2:36AM in Essbase 5 comments

Summary

Batch of calc scripts taking three times more time to complete

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!