Calculate Level Based Measure across all levels of hierarchy — Oracle Analytics

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

Calculate Level Based Measure across all levels of hierarchy

Received Response
3
Views
3
Comments
mlov83
mlov83 Rank 4 - Community Specialist
edited Aug 13, 2024 5:16PM in Oracle Analytics Cloud and Server

I have created a level based hierarchy in my rpd.  The hierarchy works pretty well but depending in which level of the hierarchy I'm in  the amount does now show up. I'm wondering if there is a way to always have the total amount always show regardless of level in the hierarchy. The hierarchy looks like this.

1.png

In the front end I can pull the the hierarchy and dropped it on my report as a table prompt like such.

2.png

If I'm at the lowest level of the hierarchy the amounts show up. However, if I'm hierarchy up in the hierarchy I don't see the amounts

3.png

Is there a way to tell obiee to always  calculate the amount no matter what level of the hierarchy I'm in?

Any help would be greatly appreciated.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    mlov83 wrote:Is there a way to tell obiee to always calculate the amount no matter what level of the hierarchy I'm in?

    Yes. By NOT making it a level.-based measure. The name says it: "level-based". Based on a level.

    If you do not hardcode a level it will react dynamically. That's the whole point of the tool.

  • mlov83
    mlov83 Rank 4 - Community Specialist

    Thanks for the reply Christian. One small caveat that I fail to mention is that when I set the amount at the highest level it properly gives me the total amount of the invoice, So I guess what I really need to do is something like a calculated field in the rpd that would so something like "sum(invoice_amount by Invoice)". The invoice can have several lines but I always want to capture the total amount of the invoice regardless of how many line items are in the invoice. It does not appear like I can do "sum(invoice_amount by Invoice)" in the rpd,  I'm I missing something? I can do that in formula in the analysis I just can't seem to be able to do it in the RPD. Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You're not being specific enough.

    Is "Invoice" a level in a hierarchy? Does it break down into line items? Or is it the granular level? You will need to provide more information as at the moment it still sounds like you're just tieing the measuer to the wrong level. I.e. ANY level whereas it shouldn't be tied to anything and just aggregate dynamically