epbcs - Aggregation performance issue
Summary
epbcs - Aggregation performance issueContent
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");
0