Oracle Fusion Data Intelligence

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

How to link 2 views?

Accepted answer
21
Views
3
Comments

My requirement is to have a view where I join Legal Employer Name with Business Unit Name (red) and make the difference between green fields.

I know that Legal Employer and Business Unit are different concepts but weird choices were made in the past and now I need a way to make the difference between these 2.

image.png

Thank you

Tagged:

Best Answer

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist
    Answer ✓

    Hi @Stefano_Mazzocca,

    Ideal solution would be creating both measures at respective levels in your warehouse and extend the semantic model to accommodate those into the corresponding Subject Areas. This way you can use those as a readymade columns and just do the subtraction in the report to get the difference between the columns.

    As LE & BU are 2 different dimensions, not sure if it is possible to calculate 2 different measure values and their differences on the fly within the Report.

    Cheers,

Answers