Analytics Software

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!

Default To prompt

819380Feb 21 2011 — edited Feb 24 2011

Dear All,
I have dashboard prompt.
DateTime Between like From: To:

My data's like
DATETIME:
1/13/2011 6:00:00 AM
1/13/2011 6:15:00 AM
1/13/2011 6:30:00 AM
1/13/2011 6:45:00 AM
1/13/2011 7:00:00 AM
1/13/2011 7:15:00 AM
.
.
.
.
.
1/13/2011 10:00:00 PM
1/13/2011 10:15:00 PM
1/13/2011 10:30:00 PM
1/13/2011 10:45:00 PM

My dashboard prompt i should set default to:
From date: 1/13/2011 7:00:00 AM To date:1/13/2011 10:00:00 PM (7 am into 10 PM)

How to set default to. If i choose SQL Query What query can i use.
Send me syntex or any other way is there?

Thanks

This post has been answered by David_T on Feb 22 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2011

Added on Feb 21 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

108 views