Skip to Main Content

Analytics Software

Filter Measure using Variable

729747Nov 27 2009 — edited Dec 3 2009
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)
Comments
Locked Post
New comments cannot be posted to this locked post.