6 Replies Latest reply: Nov 19, 2012 11:24 PM by 975128 RSS

    OBIEE Presentation Variable

    975128
      Hi,

      I have a presentation variable called P_DATE which reads the data from a Calendar Table

      In my BI Answers query, I would like to get the data from Previous Day to P_DATE.

      How can I apply an expression to my P_DATE variable to get Previous Day date

      i.e. SELECT DATEADD(Day, -1, P_DATE)

      Note: The Source Database is a SQL Server Database which is why I am using SQL Server based functions

      Thanks