Suppress measure against dimensions in analysis — Oracle Analytics

Oracle Analytics Cloud and Server

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

Suppress measure against dimensions in analysis

Received Response
21
Views
5
Comments
ark86
ark86 Rank 3 - Community Apprentice

Hi,

I want to make a report listing vehicles and salary of vehicles.

When i add Agent Name, Vehicle Name, and Salary, it repeats salary against vehicles as one agent has more than vehicles.

pastedImage_0.png


You can see the total is also incorrect.

How can i get following output?

pastedImage_1.png

Thanks.

Answers

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

    Not sure this is even conceptually possible since "value suppression" means dimensional attribute value suppression and not measure suppression. It's a level-based measure in your case and will always be repeated. Because it's a measure.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    What you are struggling with is 'query grain' ... really to show the correct information is to split out the agent from the vehicle (via the method @Christian Berg has mentioned):

    Agent Name     |     level based measure at Agent     |     Vehicle     |     base measure

    -----------------------------------------------------------------------------------------------------------------

    Agent 1                         5000                                              Honda                    1500

    Agent 1                         5000                                              Toyota                    3500

    -----------------------------------------------------------------------------------------------------------------

    Agent 2                         15000                                            Suzuki                    500

    Agent 2                         15000                                            Audi                        10500

    Agent 2                         15000                                            Nissan                    4000

    -----------------------------------------------------------------------------------------------------------------

    TOTAL                           20000                                                                          20000

    With the proper logical constructs you can then have a master-detail table; master shows the agent and total; click the agent and detail shows you the vehicles and their contribution to total.

  • ark86
    ark86 Rank 3 - Community Apprentice

    I understand that it was a wishful thinking but it was a requirement. I've handled this at DB end. Thank you for your valuable input.

    Regards,

    ARK

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    A requirement is an agreed upon item to be worked ... when an ask isn't inline with functionality of the tool it should ever become a requirement. 

  • ark86
    ark86 Rank 3 - Community Apprentice

    I agree. Thank you very much for your help.

    Regards,

    ARK