Filter Measure using Variable
729747Nov 27 2009 — edited Dec 3 2009Hello 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)