epbcs - Aggregation performance issue

Summary

epbcs - Aggregation performance issue

Content

Hi All,

We are seeing huge performance issue with aggregation business rules. We are aggregating 4 Sparse dimension with alternate hierarchy as well. Aggregation is taking around 2 hours 30 minutes to complete. We tried with less data (5 page files) and cleared zero as well, but  still taking more than 2 hours complete the aggregation. Attached dimension members stat. Can someone will guide to improve aggregation performance.

 

Thanks

Senthil

 

 

Code Snippet

 FIX (@RELATIVE("Total Plan", 0)
    /*All Plan Elements*/
    , @RELATIVE("PlanningACC", 0), @RELATIVE("WFAccounts", 0)
   
    , &OEP_RollingFcst, "Jul" : "Jun") 
        FIX ("USD_Reporting") 
            AGG ("Site");
            AGG ("Department","Projects");
            @IDESCENDANTS("OEP_Total Entity");
            @IDESCENDANTS("Region");