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

Calculation Scripts performance issue.

Received Response
25
Views
12
Comments
edited Aug 2, 2018 2:36AM in Essbase 12 comments

Summary

Calculation Scripts performance issue.

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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