Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
E-Business Suite Technology
Business Intelligence (EBS)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 4, 2013 6:07 AM by
Date Prompt in OBIEE 22.214.171.124.0
Jun 4, 2013 6:07 AM
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?
This content has been marked as final.
Show 0 replies