Oracle Analytics Cloud and Server

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

How to Pass Value from one report to the 2nd report and compare the column value in the 2nd report

Received Response
235
Views
15
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3283945 wrote:I am referring here to OBI analyses(Subject Area) where both analysis are it's own report.

    Let's just assume that this is trolling.

  • Before to go into the detail of your question (or what I understand of it) let's fix a detail of "wording" :

    What Christian was pointing out is that you call "report" a thing done in BI Publisher, while if you do that thing in OBI Answers (using a subject area etc.) the name is "analysis".

    So when you say it's an analysis but then you call it report, it's confusing as there is a doubt about what tool / technology you are really using.

    It's all about wording, things have a name and it's easier if we all stick to the same wording.

    (You maybe now see better why saying "both analysis are it's own report" is quite ... fun )

    Now, back to your question ...

    You have 2 analysis (and not reports), one gives you employee, job code and grade, the other one gives you job code and grade.

    What I understand is that you want a way to compare the couple job code - grade between these two analysis, is that right?

    And if the couple job code - grade isn't the same in the 2 analysis you would like to see something (a color, an icon or any other visual thing) in the analysis with just the job code and grade showing you which couple job code - grade mismatch.

    Right?

  • 3283945
    3283945 Rank 2 - Community Beginner

    Thank you for clearing the confusion on wording @Gianni Ceresa.

    your interpretation is accurate.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    isn't that what I said yesterday?

    Now 3283945 ... when you pass one value from an ANALYSIS to another you are doing so as a filter ... you are better off showing both reports and letting the user input the target (value from ANALYSES 1) and use that in ANALYSES 2 ... you really aren't filtering with that value, rather you are calculating.

    Use a prompt and a presentation variable and you can do the conditional formatting you want.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Thomas Dodds wrote:isn't that what I said yesterday?

    It is