Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Prompt in OBIEE 11.1.1.7.0

RaynoMJun 4 2013
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2013
Added on Jun 4 2013
#11g, #applications, #business-intelligence-ebs, #custom, #interface, #oracle, #personalization
0 comments
986 views