1 Reply Latest reply: Feb 20, 2013 7:50 AM by pjglobo RSS

    Running Aggregate on grand totals

    Aravinda.L
      Hi,

      We have requirement where user wants to view running aggregate only on the grand total,when we use running aggregate in OBIEE 11g it calculates running totals each row, however we want the running totals on grand totals.
      Another issue is can we show grand total row and running total on the grand total in the same report like the following report.

      This is how the report should look however when we apply running aggregate it is calculating the totals for all the cells in OBIEE, Could any one let us know how we can achieve this.


      Current report

      Branch        W1     w2     w3      w4
      Abc 10 1 10 11
      MNC 20 2 5 10
      XYZ 30 3 1 20
      QCW 40 5 0 10
      ---------------------------------------------------
      Grand Total  100   11        16       51
      ----------------------------------------------------

      Expected report with Running aggregate on grand total


      Branch            W1     w2     w3      w4
      Abc 10 1 10 11
      MNC 20 2 5 10
      XYZ 30 3 1 20
      QCW 40 5 0 10
      ----------------------------------------------------
      Grand Total 100 11 16 51
      -----------------------------------------------------
      Running Total   100    111    127     178
      ---------------------------------------------------------
        • 1. Re: Running Aggregate on grand totals
          pjglobo
          So having this:

          Branch W1 w2 w3 w4
          Abc 10 1 10 11
          MNC 20 2 5 10
          XYZ 30 3 1 20
          QCW 40 5 0 10

          To achieve what you want you should add a union on the analysis where you set the Branch Column to 'Running Total'.
          In the metric you just have to do a RSUM(facts) and they will be aggregated as an RSUM by Week.

          Let me know if it works.