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 Aggregation Performance Improvment

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

Summary

Essbase Aggregation Performance Improvment

Content

Hi Everybody,

my name is Maurizio and i'm trying to improve the perfromance of aggregation in Essbase. we're running on 11.1.2.4 launching the br from Planning.

I need to aggregate 4 sprse dimensions and it takes very much time to complete teh calculation (about 1h).

I know the application is not optimized and not well designed.

I tried diefferent solutions:

1) using a unique CALC DIM(4 dimensions)

2) using a unique AGG (4 Dimensions)

3) doing a prtial aggregation dimensions by dimension as reported in teh code below

i got some improvement by using the third solution but i wanted to ask you if you have any other idea i can try to aggregate my data.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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