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

Aggregation performance decrease

Received Response
72
Views
7
Comments
edited Aug 10, 2020 9:45AM in Planning 7 comments

Summary

After doubling the number of members in one dimension, aggregations take 4x longer

Content

 

 

Hi all,

 

Due to functional requirements, our Product dimension has increased its number of members from 1700 to 3200, so almost double. Since then, aggregations are taking not just twice the original time, but more than 3 or 4 times.

Here I share an example:

 

SET CACHE HIGH;
SET LOCKBLOCK HIGH;
SET CALCPARALLEL 8;
SET AGGMISSG ON;
SET CALCTASKDIMS 1;
SET FRMLBOTTOMUP ON;
SET UPDATECALC OFF;

 

FIX(&Bdgt_Year,&Bdgt_Scen,"BegBalance","Jul":"Jun",@RELATIVE("Tipo",0),"Objetivo","Trabajo",@IDESCENDANTS("RT02"), IND_A1_C)
   FIX(@LEVMBRS("Total_Mercado",0),@IDESCENDANTS(&quot

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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