SOLVED ! I was able to create this logic as below - Create 2 session variables to Last quarter completed - start date and Last 4th completed quarter start date SELECT DISTINCT H.CAL_QUARTER_START_DAT…

Query for session Variable creation - SELECT DISTINCT H.CAL_QUARTER_START_DATE from DW_QUARTER_D G , DW_QUARTER_D H where G.CAL_QUARTER_CODE in ( SELECT DISTINCT F.CAL_QUARTER_CODE from DW_QUARTER_D …

Thank you!! @Mallikarjuna Kuppauru-Oracle for responding promptly.

Hi Gabby, Avinash, I got the resolution from Oracle SR. understood that overall Dashboard filters are different that workbook filters (at the top), Workbook filters are not retained in FAW-OAC style …