2 Replies Latest reply: Jul 26, 2013 4:51 AM by JB1 RSS

    Aggregate All

    user11081975

      Dear all,

       

      I am currently using hyperion planning 11.1.2.3, I created a business rule to aggregate data (Calc all) :

       

      Account and period dimension are set as dense, all other dimensions are set as sparse.

       

      I have a problem when I launch the business rule : it takes a lot of time, more than 10 minutes to complete!

       

      do you have any idea to circumvent this issue?

       

      thank you.

      best regards

      Toufik

        • 1. Re: Aggregate All
          _RahulS_

          What is the size of cube?

          What is the difference between number of page files before and after aggregation?

          What is the hit ration on Index and Data Cache?

          Is that a migrated application? How much time it was taking to aggregate in base version?

           

           

           

          Few general things to reduce the calc time:

          1. Using Parallel Calculations,

          2. Calc Taskdim,

          3. Increasing data and index cache depending on hit ratios,

          4. Hour glass/ Hour glass on stick,

          5. Restructuring etc

           

           

          Cheers..

          Rahul S.

          • 2. Re: Aggregate All
            JB1

            Hi

             

            If you think 10 minutes is a long time I dread to think what you would make of some of our calcs!!

             

            Try changing your rule to just an 'aggregate' command on your sparse dims and see how long that takes....my guess is that calculating the dense dims is probably responsible for the majority of the calc time. If so then changing the dense dims so upper level members are dynamic might be the best bet, but what implications this could have on the functionality on the rest of your model I cant be sure.

             

            Cheers

             

            JB