Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Cumulative snapshot fact over months

Received Response
2
Views
2
Comments
4012290
4012290 Rank 1 - Community Starter
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

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".

pastedImage_0.png

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

pastedImage_1.png

Thank you for your time in advance.

Answers

  • M De Fanti
    M De Fanti Rank 2 - Community Beginner

    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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.