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

RSUM

Received Response
21
Views
4
Comments
Joe Choueiri-Oracle
Joe Choueiri-Oracle Rank 5 - Community Champion
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

Hi

I am trying to create a report as the one in the image below, revenue week over week by region, if we notice the revenue is running sum.

pastedImage_0.png

Now if I create it and show it by week as the image below it works fine

pastedImage_1.png

The minute I add region or product the numbers start to not make sense. the question is how come? thank you .

pastedImage_2.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Your numbers seem to make sense, just in a different way

    APAC FYW40 = 14,614 USD & RSUM: 14,614

    EMEA FYW40 = 41,946 USD & RSUM: 56,560 = 14,614+41,946

    So the RSUM is doing the sum by region first and then jumping back to fiscal week.

    To keep the RSUM inside the region week by week (so each region restart from 0 and the RSUM sum only week after week of the same region) you can edit the RSUM formula to fix the level by adding a "by <region>" (where <region> is the reference to your column, for example: RSUM("Revenue Metrics"."Revenue" by "Geography"."Region") )

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    Thanks @Gianni Ceresa

    I tried that but it did not work...do I have it wrong? here is the image of my formula

    pastedImage_0.png

    But then I ended up with this

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    The good new is the formula looks good, the bad news is that your analysis/model is weird

    As you can see with a normal model and a normal analysis it just works fine. As yours isn't working at all ... there must be something weird...

    Can you look at the generated query (logical and physical) to find out what's going wrong?

    Capture.PNG

    Capture2.PNG

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    I redid it from the beginning and it worked, thank you @Gianni Ceresa