Jan 2024: I still don't see anything related to download-related fine-grained permissions :( . Not sure why it is marked as delivered.

Have you tried using 'Choice List Values' as SQL Results? in the prompt itself. And have the SQL with restricted values ...Here is one sample example: instead of showing all year values from date dimension. I am showing only years that logged in user created an SR. SELECT "Time"."Year" FROM "Service - CRM Service Requests…

How about recording browser actions then replay when needed.

SUBSTRING("Worker"."Primary National Identifier Number" FROM LENGTH("Worker"."Primary National Identifier Number")-3 FOR 4)

If you are looking from front end only how about advanced SQL select b.s_1, a.s_1,a.s_2,a.s_3 from (SELECT "Your Subject Area"."Procedure Date" s_1, "Your Subject Area"."Report Date" s_2, "Your Subject Area"."Procedure Number" s_3, FROM "Your Subject Area" ) A, (select "Date Dimension"."Date" s_1 FROM "Your Subject Area")…

The above logic will repeat the rows. Calender Date Procedure Date Report Date Procedure number 1/1/20191/1/20195/1/20191234562/1/20191/1/20195/1/20191234563/1/20191/1/20195/1/20191234564/1/20191/1/20195/1/20191234565/1/20191/1/20195/1/2019123456 If you are looking to populate Report Date to the last record then have a…

How about complex join with Date Dimension Understanding Complex Join and Physical Join in OBIEE ~ Best Way To Understand BI and Data Visualization And How Everyth… Date_Dim.Date >= Procedure_Date and Date_Dim.Date <= Reported_Date

Hi Christian & Gianni Thank you for the suggestions, I will consider whatever I can. Prior to the upgrade, this dirty SQL uses to complete in less than 2 mins or so, now taking more than 20mins hence we are killing the SQL on the database. I have compared DB "Features" on both versions they match identically. Also, I have…

Yes, it matches. SELECT * FROM v$version; Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Hi Christian, I have compared post deployed RPD's and I see everything as identical. Database Type : Oracle 12c on Exadata Thank you,Srini