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

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

    Re: Running Total

    ‏2013-03-27T14:42:12Z  
    Someone can help me ?

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

    Re: Running Total

    ‏2013-03-29T19:41:15Z  
    Someone can help me ?

    I try somethine with 2 queries, but dont work like i need.
    Try using he running-total function available in COGNOS.
  • Rick_J
    Rick_J
    138 Posts

    Re: Running Total

    ‏2013-04-03T14:26:50Z  
    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

    Re: Running Total

    ‏2013-05-13T20:13:12Z  

    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