Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Essbase Aggreation Script...Can you spot a difference?

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

Summary

Essbase Aggreation Script...Can you spot a difference?

Content

Hello Forum,

We are having some performance issues when running aggregations on our BSO database.  The database is fairly large and aggregation times have now increased to a few hours even when we fix at a parent with only two descendants.  I looked at the aggregation code and it is a follows:

FIX({Version_Limited},&Crt_Forecast,&FcstYr)

    AGG ("Job Title","Employee","Positions");
    @IDESCENDANTS({Acct6});
ENDFIX

I'm by no means an expert on calc scripts but something tells me this script is not correct.  As an example, if the Acct6 is set to a parent with only two descendants to aggregate, it still takes about an hour.  However, if I move the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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