Skip to Main Content

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!

False midnight filtering

3167342May 5 2016 — edited May 5 2016

Greetings all,

We have an OBIEE dashboard that is used to basically count the number of widgets we produce a day.  This dashboard is displayed on a console that is updated every 5 minutes or so to the floor supervisors.  The problem we have ran into is working the filter work with our plant's false midnight.  For example our plant day is from 0500 to 0459 the next morning.  Does anyone have any hints as to how to setup the filter to handle only searching for data that occurred on the current day between those times?

Example:

Plant day would be from April 1, 2016 0500 until April 2, 2016 0450.

Wes

Comments

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