7 Replies Latest reply on Jul 20, 2017 1:49 PM by FTisiot

    Last week details in OBIEE 11g

    961614

      Hi All,

       

      I am trying to create last week details report. I am able to get the required details by using below condition, but I have created presentation variable called "pd" and how to pass that variable.

       

       

       

       

      "Times"."DATEMAKE"  >=TIMESTAMPADD(SQL_TSI_WEEK,-1,CURRENT_DATE)

       

       

      Kindly help how to call variable in above condition.

       

      If user select any date, it should fetch last week complete data.

       

       

      Thanks,

      Ramesh