Answers: Table/Pivot Sum and group — 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

Answers: Table/Pivot Sum and group

Received Response
11
Views
3
Comments
Muhammad Jahanzaib
Muhammad Jahanzaib Rank 4 - Community Specialist
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hi,

I am using OBIEE 10g, In Answers, I want to achieve as shown in below table:

   

Purchase Order NoPO AmountMRN NoAmount
10002568810080010012861325000
10080010013006025400
100025688 Total10080050400

Note: Po Amount Aggregation Rule is SUM

How can I achieve this.

Thanks,

JB

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Ideally you must correct your model to have the PO Amount with the double meaning: measure in your fact table with a SUM aggregation and in the same time also an attribute without any aggregation (a degenerated dimension exposing the PO Amount as attribute).

    Plan B you can change the aggregation to Average, it's probably enough to look like it's what you want ...

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    Actually, the question is: what is the problem?

    This report looks pretty usual for me, and some comments are required on what do you have now and what do you want to achieve.

  • Muhammad Jahanzaib
    Muhammad Jahanzaib Rank 4 - Community Specialist

    Thanks. It helped.