Topic
4 replies Latest Post - ‏2013-05-13T20:13:12Z by rperzul
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic Running Total

‏2013-03-27T10:29:23Z |
Hi,

I need your help to do a running-total

I want that :
MONTH CUSTOMER REVENUE RUNNING-TOTAL
01 APPLE 5000 5000
02 APPLE 0 5000

I have that :
MONTH CUSTOMER REVENUE RUNNING-TOTAL
01 APPLE 5000 5000

There is no value for this customer in the second month, then the running-total dont work with something who don't exist.

How to do what i want ??

Thanks for helping me.
Updated on 2013-04-03T14:26:50Z at 2013-04-03T14:26:50Z by Rick_J
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Running Total

    ‏2013-03-27T14:42:12Z  in response to SystemAdmin
    Someone can help me ?

    I try somethine with 2 queries, but dont work like i need.
    • neni
      neni
      42 Posts
      ACCEPTED ANSWER

      Re: Running Total

      ‏2013-03-29T19:41:15Z  in response to SystemAdmin
      Try using he running-total function available in COGNOS.
  • Rick_J
    Rick_J
    138 Posts
    ACCEPTED ANSWER

    Re: Running Total

    ‏2013-04-03T14:26:50Z  in response to SystemAdmin
    Here's a link that will help explain the running total function as previously mentioned.

    http://www-01.ibm.com/support/docview.wss?uid=swg21341296
  • rperzul
    rperzul
    25 Posts
    ACCEPTED ANSWER

    Re: Running Total

    ‏2013-05-13T20:13:12Z  in response to SystemAdmin

    Hi,

    you are right, no record when using an inner join between fact and dimension(s). Have you considered using an outer join between fact and time dimension (in FM or RS)?

    Regards,

    Ron