Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

element calculated in the selection steps

Question
1
Views
0
Comments
User_I0GH4
User_I0GH4 Rank 3 - Community Apprentice
edited Aug 13, 2024 7:10PM in Oracle Analytics Cloud and Server 
I would like to know if it is possible to make this element calculated in the selection steps instead of choosing the year which will change each year.

Thanks


SELECT "Période conclusion de contrat"."Exercice financier conclusion contrat" FROM "SEAO" WHERE ( ( ( ("Période conclusion de contrat"."Exercice financier conclusion contrat" IN  (cast(year(TIMESTAMPADD(SQL_TSI_MONTH, -3, current_date) )-2 as char(4) ) || '-' || cast(year(TIMESTAMPADD(SQL_TSI_MONTH, -3, current_date) )-1 as char(4) ) ) ) ) ))