1 Reply Latest reply: Nov 2, 2012 5:09 AM by Stuart Game RSS

    Calc script running for a long time

    948778
      Hi Gurus,

      I have a calc script running for a very long time for about 30 ~ 45 mins

      Can any one please let me know what all i need to consider to increase the performance of any calc script


      Regards,
      945775
        • 1. Re: Calc script running for a long time
          Stuart Game
          Hi

          You could start by posting the calc syntax and some details about your application (# dimensions, dense / sparse settings) so that we can get an idea of what you are trying to achieve. There are some standard things to consider, some that you may need to do some reading up on in the Essbase dbag / tech ref documentation:

          BASIC CALC SETTINGS:
          - SET AGGMISSG ON/OFF (for aggregation)
          - SET UPDATECALC ON/OFF (turn on/off intelligent calc if approriate)
          - SET CALCPARALLEL n (how many threads are you assigning to the calc)

          APPLICATION SETTINGS:
          - INDEX CACHE
          - DATA CACHE
          - DATA FILE CACHE

          BASIC CONFIG SETTINGS:
          - CALCLOCKBLOCK
          - CALCCACHE HIGH/DEFAULT/LOW
          - DYNCALCCACHE


          Hope this is a useful start point
          Regards
          Stuart