Calculation Performance issue - execution taking more time

Aug 9, 2019 11:52AM

Summary

Hi Team,

We are facing calculation performance issue for below application and as details are below,

1. We have 13 dimensions in the application.

2. We have two modules in A. Budget and B.RCR(Route Contribution Report).

3. In Budget Cube,Account and Period are Dense dimensions and remaining dimensions are Sparse dimensions.

4. Here below we mentioned one calculation manger rule it executing more than an hour .

SET AGGMISSG ON;

SET UPDATECALC OFF;

SET CALCPARALLEL 8;

SET CALCTASKDIMS 4;

FIX (Target, &BudYr)

FIX ({Entity}, {Currency}, @Relative("YearTotal", 0))

FIX ("FlightCount", Budget, "No Costcentre", "No SubAccount2", "No Currency", "No Location",