I do not have the setup to try above sql, but see if it can be simplified like CASE WHEN MONTH(CURRENT_DATE) IN (1,2,3) THEN TO_DATE(CONCAT(TO_CHAR(YEAR(CURRENT_DATE)-1), '-03-31')) ELSE TO_DATE(CONCAT(TO_CHAR(YEAR(CURRENT_DATE)), '-03-31')) END Hope it helps!

Hopefully you got a chance to review this document, Refer Chapter 5 (page 59 onwards) creating-and-administering-analytics-and-reports-for-procurement.pdf Hope it helps!

I agree this ( approach suggested by Sushil ) might work in this situation. I have not got a chance to work on it so would like to see if it works for you. Thanks

I do not think there is a standard out-of-the-box column in Oracle Transactional Business Intelligence (OTBI) subject areas for the invoice-attachment URL. You might need to get the help from Oracle by logging SR to see if they have any approach which can help in this situation. Thanks

To understand the concept of adding an attachment URL to the underlying data, watch this video: Bring AP Invoice Attachment URLs into Fusion Data Intelligence - Oracle Blogs. This link demonstrates how to expose AP Invoice Attachment URLs in Oracle Fusion Data Intelligence using Data Augmentation and Semantic Model…

I believe following youtube video is answer to your question, it is recently published by Oracle Analytics Team. Semantic Model Extensions: Migrate to the Sandbox Framework Hope it helps!

Are you able to identify Knowledge Management PVOs and confirm these are accessible via the Oracle Business Intelligence Cloud Connector (BICC)? If not, then you might need to get in touch with Oracle Support to find the PVOs. If yes, then try if FDI Data Augmentation capabilities can be utilized to fulfill your…

Can you please share how did you create a custom dimension and chose the seeded subject area?

@Benjamin Arnulf-Oracle - Reason, I had asked this question because I was trying to Register for the " Exam 1Zo-1123-25" and saw "Buy Exam" Button and it expects me to pay for it - "One single-use exam for a technology or OCI certification" Do you expect it to be the process where I pay first and then get some sort of…

I will take a look. Thank you so much, appreciate it.

Thank you so much! Looking forward to learning and collaborating with Oracle to make it success.

Thank you so much! Looking forward to learning and collaborating with Oracle to make it success.

Thank you so much! Looking forward to learning and collaborating with Oracle to make it success.

It is definitely exciting to be part of something which is just starting. Looking forward to the fun!

Do you know if it is available for free tier so that community can learn and build some knowledge base around it.? Thanks

Thank you for doing it. Is there a plan to record and share the session for folks who cannot attend online?

It was such a nice initiative. Is there any plan to extend the date?

Is there a way Oracle Partners can participate in it?

This is exciting. Looking forward to learning and participate in the community.

Hoping that it will be recorded and shared with folks who cannot join on Thursday!