6 Replies Latest reply on Nov 20, 2012 5:24 AM by 975128

    OBIEE Presentation Variable


      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