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

In OAS, data on second report is not filtering as first report while using action link.

Accepted answer
64
Views
3
Comments
User_88CSQ
User_88CSQ Rank 1 - Community Starter
edited Aug 13, 2024 6:04PM in Oracle Analytics Cloud and Server

Hello,

In OAS, data on second report is not filtering as first report while using action link.

I have first report in which for one of the columns, I have given an action link so that it goes to second report. first and second report both has receipt date filter which is coming from different fact tables. when I am giving filter of receipt date like receipt date between 1-feb-24 and 29-feb-24 to first report, it is filtering data on the first report as expected, but after that when I am going to second report from first through action link then it is not filtering the data on second report as per the filters applied on the first report. On the second report, receipt date is not populating like first report and data is showing irrespective of feb-24 month. All the data is visible.

I tried with the presentation variable but its not working.

Appreciate your help!

Thanks in advance!

Best Answer

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod
    Answer ✓

    Hi @User_88CSQ ,

    I would use the following approach:

    1. Add each analysis to a dashboard page
    2. Create a dashboard prompt with 2 variable prompts (e.g. PV_Start_Date and PV_End_Date). It doesn't matter which table/column you use to initialize the available values as long as you create them as variable prompts
    3. Add the dashboard prompt to both your dashboard pages
    4. Update the filters in your analyses to use the presentation variables (e.g. DateColumn >= @{PV_Start_date} AND DateColumn <= @{PV_End_Date} )

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

     first and second report both has receipt date filter which is coming from different fact tables

    Does this mean that the "receipt date" in your 2 reports are technically 2 different presentation columns? Even if both have maybe the same name and the same meaning, they do have 2 different logical columns behind?

    If that's the case, then it is expected that your second analysis doesn't filter the "receipt date", because there was no filter on it in the first analysis (it is maybe named the same, but technically it's different columns).

    If you have no way to have the same columns as the 1st analysis in the second, then you could think at building the navigation link by hand and passing the values of the "receipt date" to the column that has the same meaning in the second analysis.

  • User_88CSQ
    User_88CSQ Rank 1 - Community Starter

    Hi @Federico Venturin,

    As you suggested, I applied the same logic and its working fine. It really helped me.

    Thanks a lot!