Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

In case anyone's looking for an answer, I’ve successfully made it work: FILTER(AGGREGATE(Column AT Fiscal Year) USING Fiscal Year = '2025') You can also replace '2025' with a Year parameter, so the calculation will be dynamic.

in How to get the Full Year based on Current Month in OAC DV? Comment by Hesham Khalil © May 23, 2025 1:51PM
Hi @Sumanth V -Oracle, Thanks for looking into my query. I appreciate the reasoning behind your measure and would like to gain clarity on its implementation, as I believe it has the potential to benefit the community. One more thing to clarify, FIRSTOFYEAR is not available in DV, right? Also, Period is a data type of text.…

in How to get the Full Year based on Current Month in OAC DV? Comment by Hesham Khalil © Apr 26, 2025 11:52AM