3 Replies Latest reply on Jul 4, 2018 10:09 AM by Teresa Modesta

    PBCS - Can Intelligent Calculation be useful?

    Teresa Modesta




      when I first looked into Intelligent Calculation it seemed useful.


      Then I saw that you needed to calculate the entire database for blocks to be marked clean, and marked it down as an opportunity lost in my own mind.


      Recently I saw in the Essbase documentation; 'SET CLEARUPDATESTATUS' ..... "AFTER - Marks blocks as clean , even if you are calculating a subset of your database"


      So now I am thinking that to minimise unnecessary aggregation processing is it worth using SET CLEARUPDATESTATUS AFTER in conjunction with SET UPDATECALC ON in my pure aggregation scripts.


      My question then is is the above observation valid, is it worth using the settings I describe in the way that I describe?

        • 1. Re: PBCS - Can Intelligent Calculation be useful?
          Robert Angel




          I recently experimenting with this on PBCS.


          Others experience my be different - please chip in if you have -  but I noticed virtually no performance difference when comparing with a baseline aggregation that originally had intelligent calc off, with a aggregation that was taking ~2 minutes to run.


          This was when experimenting against 3 different scenarios; -


          1. Previously processed, so you would expect the dirty only process to have most effect

          2. Only a single combination of data dirty, so again you would expect a considerable improvement processing dirty only

          3. After a very large scale change when you would expect minimal difference between the two aggregations


          My only problem is with PBCS tuning benchmarks is sometimes my aggregations are massively variable with no user load on the system (up to a factor of 3 times longer) which I am guessing is down to share of physical server cpu on the Oracle Cloud server farm...

          • 2. Re: PBCS - Can Intelligent Calculation be useful?
            Teresa Modesta

            Mmmm - not a glowing endorsement, anyone else have a genuinely good result using the settings I describe to use intelligent calculation in a less than full cube aggregation?


            I also have massively variable aggregation times with the same script and no database load to explain it...

            • 3. Re: PBCS - Can Intelligent Calculation be useful?
              Teresa Modesta

              In the end I followed your lead and ran a few tests, and sadly reached the same conclusion.


              Couldn't find anything in the log files that made it obvious that intelligent calc was not processing clean data, so would be interested if anyone can confirm that, but for now closing this question as no other useful input is incoming and from my own tests it does not seem to help.


              Thanks sweetie!


              Teresa X.