ESSBASE Calcscript
Summary
ESSBASE CalcscriptContent
Hi Folks,
Can you help me on below query,
SET CACHE HIGH;
SET CALCPARALLEL 2;
FIX (@Relative("TotalCostCentre",0) - 3000 level0 members,@Relative("XYZ",0) - 140 level0 members,@Relative("TotalABC",0) - 60 level0 members,&CurrMonth, &CurrYear, &Scenario, &Postn,"No_Cool","No_Costy","No_HUB","No_CostType")
"No_Account" = 0; --> Took around 10 minutes
"No_Account" = #MISSING; --> Took around 10 minutes
Cleardata "No_Account"; --> Took around 10 minutes
ENDFIX
How can i reduce the time
Thanks
0