Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Display current and next 5 years dynamically

Received Response
89
Views
1
Comments
JT_DC_2023
JT_DC_2023 Rank 4 - Community Specialist
in Oracle Fusion AI Data Platform Forum

Hello,

I am currently struggeling to to display the attrition data for the current year and the next four years dynamically. The out-of-the-box functionality allows selection for future years but omits the current year, which is critical for the analysis.

image.png image.png

Has anyone else encountered this limitation? If so, how did you address it? Any guidance or examples on setting up a dynamic time range for this use case would be greatly appreciated.

Thank you very much for the support!

Tagged:

Answers

  • Caroline Blanchard
    Caroline Blanchard Rank 6 - Analytics & AI Lead

    Not sure which subject area you're using, but using Workforce Core I was able to successfully get the current and future 4 years using the following expression filter: "HCM - Workforce Core"."Time"."Year" >= YEAR(CURRENT_DATE) AND "HCM - Workforce Core"."Time"."Year" <= YEAR(TIMESTAMPADD(SQL_TSI_YEAR, 5, CURRENT_DATE))

    image.png