This discussion is archived
1 Reply Latest reply: Jun 17, 2013 6:18 AM by Srini VEERAVALLI RSS

Column level filter at RPD level - OBIEE 11g

986359 Newbie
Currently Being Moderated

Hi all,

 

How do i add a filter at the column level in logical layer for one of the metric , it has the following calculation

 

case when id in (1,2,3,4,5,5) and category='AS' then case when points=10 or points=9 then 1 else 0 end end

 

I want the metric to reused for other id's as well... so i want to put case when id in (1,2,3,4,5,5) in filter of the column. how do i achieve it? plz help

 

 

Thanks,

Lona

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points