Skip to Content
0
Former Member
Feb 08, 2011 at 11:39 AM

Calculated Key Figures

11 Views

Hi,

I have a peculiar requirement which I need to address without using non-cumulates.

My cube output is as follows

ID - Amount

10 - 200

20 - 50 ➖

30 - 100

40 - 80 ➖

50 - 20(-)

My query requirement is

ID - Amount - Total Amount (as of day)

10 - 200 - 200

20 - 50 ➖ - 150 (200-50)

30 - 100 - 250 (150+100)

40 - 80(-) - 170 (250-80)

50 - 20(-) - 150 (170-20)

Is this possible at all using calculated key figures or any other OLAP functions?

Regards,

Suraj

Edited by: Suraj Shenoy on Feb 8, 2011 12:40 PM

Edited by: Suraj Shenoy on Feb 8, 2011 12:43 PM