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
Skip to content
  • Register

    • ESSBASE Calcscript

    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!