nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

User_88CSQ

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!

Find more posts tagged with

Accepted answers

Federico Venturin - Oracle

Hi @User_88CSQ ,

I would use the following approach:

Add each analysis to a dashboard page
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
Add the dashboard prompt to both your dashboard pages
Update the filters in your analyses to use the presentation variables (e.g. DateColumn >= @{PV_Start_date} AND DateColumn <= @{PV_End_Date} )

All comments

Gianni Ceresa

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.

Federico Venturin - Oracle

Hi @User_88CSQ ,

I would use the following approach:

Add each analysis to a dashboard page
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
Add the dashboard prompt to both your dashboard pages
Update the filters in your analyses to use the presentation variables (e.g. DateColumn >= @{PV_Start_date} AND DateColumn <= @{PV_End_Date} )

User_88CSQ

Hi @Federico Venturin,

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

Thanks a lot!