3 Replies Latest reply: Jul 25, 2012 6:36 AM by SH RSS

    Cumulating data during load to essbase.

    GregGaszewski
      Hi Guys!

      I have relational data like that:
      Account | Year | Jan | Feb | Mar | Apr | ...
      Acc1 | FY12| 100 | 200 | 100 | 150 | ...
      Acc1 | FY11| 120 | 100 | 0 | 250 | ...

      I am loading his data to essbase and I want to cumulate previous months during loading. What I need to have in Essbase:
      Account | Year | Jan | Feb | Mar | Apr | ...
      Acc1 | FY12| 100 | 300 | 400 | 550 | ...
      Acc1 | FY11| 120 | 220 | 220 | 470 | ...

      Current month is sum of all months from begining of the year.
      What is the best way to do that?

      Best regards,
      Greg