Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi, It definitely works in the Expression Filter...thanks. CAST("Period"."Period Name Gen 6" AS DATE) BETWEEN CAST(@parameter("SelectedDate")('2022-12-31')AS DATE) AND CAST(TIMESTAMPADD(SQL_TSI_DAY, -91, CURRENT_TIMESTAMP) AS DATE) Added it to my filter section, and now I can see values in my parameters. The Period Name is…
-
Hi, Thanks Arjun, So you are saying it should look more like this: CAST("Period"."Period Name Gen 6" AS DATE) BETWEEN @parameter("SelectedDate")('2022-12-31') AND CAST(TIMESTAMPADD(SQL_TSI_DAY, -91, CURRENT_TIMESTAMP) AS DATE) If so....still getting this: Validation of parameter values failed. Near <BETWEEN>: Syntax error…