Autopopulated Prompt with Current_Date (SYSDATE)
Content
Hello everyone,
We have a OTBI dashboard that contains analysis that is running As-Of date parameter. As-Of reporting was set up by adding SET VARIABLE PARAM_EFFECTIVE_DATE ='@{EffDate}'; in prefix.
We also created separate variable prompt EffDate to supply analysis with date in order to run it.
However, when user runs dashboard and before date is added we have usual sql error which is causing poor user expirience. In order to solve that, we want analaysis to run as of today (sysdate) as soon as user opens it and afterwards if needed, user can provide as-of date.