This discussion is archived
6 Replies Latest reply: Nov 19, 2012 9:24 PM by 975128 RSS

OBIEE Presentation Variable

975128 Newbie
Currently Being Moderated
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

Legend

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