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_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 E ,…

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

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 E , DW_QUARTER_D F where E.CAL_QUARTER_CODE in ( Select DISTINCT D.CAL_QUARTER_CODE from DW_QUARTER_D C , DW_QUARTER_D D…

We have same issue on a similar visualization - Retention Rate - Last 4 completed quarters Oracle's definition of New hire Termination - How many people got terminated in last 4 completed quarters (rolling) and at the time of termination their tenure of service was less than 1 year Divided by Average headcount - (Average…

Solved! This is what worked for me - Entire report path with report name in list of reports. and only report path in reports configuration

Hi @Ankur Jain--Oracle, @SharonAtGorilla , @JohnW-Oracle I am trying to do this… but connection is not setting up sucessfully :( could you help me ?

@Melody Herbert , @Ashish-Oracle , @ArunMalla - We have a requirement to connect to OTBI, create a Analysis and use that to join with Workforce Core subject area. Could you help in the 2nd part of this ? I am not finding any document that I can use to combine OTBI data with FAW subject areas and generate the Custom…

Could you confirm that Talent Pools are not part of any delivered pipelines in OAC.

Hi@Melody Herbert, I see that you have been asking same questions I faced. :) did you implement this ?

Hello, we have the same requirement, we need to create custom tiles / dashboard based on talent pool. Melody, could you confirm how did you populate the given data set ? Was it based on any sort of active connection between FAW and Oracle to automatically run the report and pull the data ? OR was it manual upload as file…

Add one more vote from me

Hi Abhishek, I tried providing the grants to CUSTOMDATA schema using ADMIN user login and your script for all objects under OAX_USER (also tried OAX$DW), However it's failing with "insufficient privileges" Do i need to give this access to build semantic model extension in FAW ? Thank you, Prasad

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 of dashboards. I was able to create persisting dashboard filters as shown - Thank you! for engaging on this issue

Thank you, Avinash, I raised it already :) SR 3-36689678821 : Missing data in visualization and Filter Personalization's not working Looking to talk to the person at 2 PM EST, hopefully

How could I show this to you ? Do I need to create the SR ?

Hi Sumanth, Gabby, I can confirm that personalization is not working in custom workbooks either. Thanks.

Hi Sumanth, Gabby, I can confirm that personalization is not working in custom workbooks either. Thanks.

I am sorry to keep bugging on this, but the workbook has the settings on, still it's not working in viewer mode, filters and parameters are not being persisted. The highlighted filter below is not persisting with given selection when reopened the workbook pl. let me know if this is still not doing correctly, I can raise…

what I am saying is default 'on' is not working for consumers, once they search the data by filter, they comeback, filter values are not retained.