Oracle Fusion Data Intelligence

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
30
Views
1
Comments

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.

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!

Answers

  • Rank 6 - Analytics 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))

Welcome!

It looks like you're new here. Sign in or register to get started.