Business rule Tuning
Hi ,
Need a help on tuning the below script as this take around 2 hours to execute.Did atmost all the workaround but no luck
---------------------------------------------------------------------------------------
//ESS_LOCALE English_UnitedStates.Latin1@Binary
/* Start Template:SET commands*/
SET UPDATECALC OFF ;
SET AGGMISSG ON;
SET CALCPARALLEL 3;
SET CALCTASKDIMS 2;
/* End Template:SET commands*/
/* Clear */
FIX(
"Actual"
,"FY15"
,"P01"
,"Value"
,@RELATIVE("Profit & Loss",0)
,"Co_0052"
,@relative("All Profit Centres",0)
,"LocalCurrency"
)
/* subledgers are not integrated so not needed */
"ActualVersion" == @sum("GL_Primary" ,"GL_Adjustment");
/* "ActualVersion" = "GL_Primary" + "GL_Adjustment";*/
ENDFIX;
-----------------------------------------------------------
Database dimension details
* I brought Activity below Year dimension to desing the hourglass model but that was taking more than 2 hours.