Forum Stats

  • 3,854,163 Users
  • 2,264,330 Discussions
  • 7,905,584 Comments

Discussions

Filter Measure using Variable

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)
«1

Answers

This discussion has been closed.