Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
ESSBASE Calcscript — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ESSBASE Calcscript

Received Response
15
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

ESSBASE Calcscript

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!