13 Replies Latest reply: Jan 31, 2013 4:55 AM by 901916 RSS

    OBIEE Answer : SQL Filter for one column of the Dashboard sample : 201301

    986292
      I need to filter the report on the basis of one of the filter on the column which is created by custom calculation :
      YEAR ("Order Header Attributes"."Status Date" ) * 100 + WEEK("Order Header Attributes"."Status Date" )
      and this in the Number format.

      I need the filter as : 2013 + Week(CurentWeek) -1 = 201302

      Please help me create a custom SQL filter for the same.