Cumulative snapshot fact over months

Question

Hello OBIEE pro users

I am stuck in a process to show the cumulative of current on hand amount over time.

Would you please advise if there is any way I could create a report as following?

This is the original report that shows current on hand in current month with the supply number over month which is "Drive - Fin amount"

The total is showing "On hand + supply".

My question is there any way to cumulative total column so that it will shows like below?

Thank you for your time in advance.

Gianni Ceresa · Answer

What Massimo said will do it (as your "Total" is a column/formula and not the total automatically calculated by OBIEE you are almost there).

As extension to his comment: if you have other dimensions/attributes and run into the "wrong data" (which is actually right data but not what you expected) you could bypass the issues by telling OBIEE to ignore those with AGGREGATE AT etc.

M De Fanti · Answer

Hi,

you should achieve this using RSUM funtion in your formula:

RSUM(measure).

Note: you should have in your criteria, only the measure and the "year month" detail, i you add other details and then you exclude this fields in the pivot, you'll get wrong data.

Regards

Massimo