@Gautam Pisharam-Oracle , Thanks for sharing the video and the guide, appreciate it.

@Benjamin Arnulf-Oracle, Appreciate all the effort. Thanks

@Anuradha Sadhu-Oracle, Thanks for sharing, appreciate it.

Here is the screenshot for 26A Readiness and there is nothing listed in the "Deprecated and New BI View Objects in Oracle BI Cloud Connector"

@Nikhil_Kumar @akmancalix Welcome to the Oracle Analytics Community! It seems there is nothing being deprecated in 26A, please refer What's Notable and Different in Oracle Transactional Business Intelligence

Thanks for the update!

In addition to above, I believe revisions can be linked using following join condition SELECT erh.*, erp.*,r.* FROM ess_request_history erh JOIN ess_request_property erp ON erh.requestid = erp.requestid JOIN revisions r ON r.dID = TO_NUMBER(erp.value) Please explore these tables and update here if it works for you.

@Prasad_G , Welcome to the Oracle Analytics Community! I am not sure if above tables will be able to get you the Content ID. Please explore ess_request_history and ess_request_property and see if it works for you.

@SJ77225 , Welcome to the Oracle Analytics Community! As suggested above @Brendan T , please give it a try. Alternatively, see if following approach will be better for long term solution and avoid CASE statements… Create a small Goals table (Legal Employer, Month, Goal) Load via data augmentation Join to Time + Legal…

@s.datta , thanks for providing the update. This approach was provided by Oracle Product SME so next step would be to log a SR with Oracle Support.