Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE12.2.1.4.0 - Can we achieve this in BI Answers

Received Response
11
Views
4
Comments
3822729
3822729 Rank 4 - Community Specialist
edited Aug 13, 2024 7:24PM in Oracle Analytics Forum

Dear Experts,

We are using OBIEE 12.2.1.4.0 on Linux environment. this is a brand new install with no patches applied. We are trying to meet an expectation on a report, but not sure if it can be done with BI Answers. What is required is highlighted in Yellow .

pastedImage_0.png

Please suggest how we can achieve this .

Thanks in Advance.

Rakesh


Answers

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

    How about just having two level-based measures on the respective grand total level and then subtracting the one from the other. Standard fucntionality.

  • Gianni Ceresa
    Gianni Ceresa Mod

    You create formula giving the total amount on the left, you subtract a formula giving you the total amount on the right and you have your number in a cell. You can then use a narrative view to display it the way you prefer.

    Grand total in pivot views are automatically calculated by OBIEE aggregating at the required level the column you have. If you do the same yourself by hand using AGGREGATE(... AT ...) you can achieve the exact same calculation and get by a single formula the virtual total OBIEE shows in a table or pivot view.

    EDIT: Or what Christian said if you have access to the RPD

  • 3822729
    3822729 Rank 4 - Community Specialist

    Thanks Christian. Will try your suggestion and get back..

  • 3822729
    3822729 Rank 4 - Community Specialist

    Thanks Gianni, I wili try this option and see if I can the delta in a cell. will test this and get back.