12 Replies Latest reply on Apr 28, 2015 7:32 PM by Lena Zheng

    Day of the Week Parameter

    Lena Zheng

      I am completely new to OBIEE and I am trying to figure out the most efficient way to take care of this:

       

      On Mondays, I want "Account Attributes"."Enrollment Date" = TIMESTAMPADD(SQL_TSI_DAY, -3, CURRENT_DATE) and on all other days of the week, I want "Account Attributes"."Enrollment Date" = TIMESTAMPADD(SQL_TSI_DAY, -1, CURRENT_DATE)

       

      Should I make a CASE statement in the filters in the Advanced SQL section?  How should I define Monday?  With a System variable or with a full date attribute?  If I go with the full date attribute, I'd have to cast/convert it into a day of the week.

       

      Let me know your thoughts, I'd appreciate it!