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

Adding a dynamic calc member increases aggregation time for strange reasosn

edited Aug 2, 2018 2:36AM in Essbase 10 comments

Summary

Adding a dynamic calc member increases aggregation time for strange reasosn

Content

     Hello Community,

I am adding a Dynamic calc member(X_T) in my outline which is intended to be  X * -1;

This si increasing my time for aggregation from 10 mins to close to an hour. I understand that Dynamic calc members do not create blocks and hence do not increase aggregation time. But I fail to understand the reason for this exponential increase in time.

The script for Aggregation is

SET MSG Summary;

SET UPDATECALC OFF;

SET CALCPARALLEL 8;

SET CACHE HIGH;

SET LOCKBLOCK HIGH;

SET AGGMISSG ON;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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