As mentioned above, please start a new thread and provide as much details as possible so that community members can advise accordingly. Thanks

As mentioned above, please start a new thread and provide as much details as possible so that community members can advise accordingly. Thanks

As mentioned above, please start a new thread and provide as much details as possible so that community members can advise accordingly. Thanks

@s.datta, last update on this forum was more than a year ago. Advise you to open a new thread with more details.

@User_HLD1R , you are right these PVOs are exposing the current contract rows and does not show history. HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVO HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVOViewAll You should explore full extract using custom BICC extract on PER_CONTRACTS_F. Hope it helps!

Thanks, looking forward to creating visualizations!

@Silvio Garber-Oracle , Thanks for providing this information, appreciate it!

@Mike Durran-Oracle, youtube videos are always helpful, appreciate it.

@Lalitha Venkataraman-Oracle , Thanks for sharing this great video, looking forward to using it.

@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.

@Jae.L , in case, if this column is display only, then try to make it NULL safe, essentially if it is NULL then ' ' else use CAST function. Hope it helps!