0 Replies Latest reply on Jun 4, 2013 11:07 AM by RaynoM

    Date Prompt in OBIEE 11.1.1.7.0

    RaynoM
      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?

      Regards

      Rayno Matthee