Analytics Software

Hello all,

i have got a question about an filtering measure column in oracle bi answers.

Is it possible to filter a Measure Column by using variables for Year Column in an expression for measure column

FILTER(Measure.Measure1 USING filter_expression)

I tryed to use expressions like
FILTER(Measure.Measure1 USING "Year"."Years" = VALUEOF("StVar CurrYear"))
or

FILTER(Measure.Measure1 USING VALUEOF("StVar CurrYear"))

where StVar CurrYear is a static presentaion variable with an expression EXTRACT( YEAR FROM CURRENT_DATE )

Thanks in advance)