0 Replies Latest reply: Jun 4, 2013 6:07 AM by RaynoM RSS

    Date Prompt in OBIEE

      Good Afternoon, hope you all are well.

      We have the following issue in our production environment.

      Our Exact Date prompt is causing our reports to error, the reason being is that the relevant Fact table to the prompt has no data.

      Is there a piece of SQL we can add to the prompt to say if it cannot find any data to that specific date then use SYSDATE?


      Rayno Matthee