OU Analytics For Oracle Realtime Scheduler (ORS) Reporting On Planned Shifts And Work Requires Custom Star Schema
(Doc ID 2093851.1)
Last updated on MARCH 25, 2019
Applies to:Oracle Utilities Analytics Base Platform - Version N/A and later
Oracle Real-Time Scheduler - Version 2.1.0 and later
Information in this document applies to any platform.
We will be setting up Analytics for Oracle Real-Time Scheduler (ORS).
We have also executed the list of batch jobs, and attempted to analyze the data. It appears that the Analytics reports, and the data extracted from ORS is mostly for completed activities and shifts.
Are there any out of the box reports on planned utilization? For instance, number of hours of work planned for next week, number of available crew shift hours, planned driving distance and time, etc.?
Which extracted files are (or could be) used in such reporting?
If this info is not currently exported in the extraction process, are there any plans to do so?
If we want to report on this info how would we go about exporting the appropriate data from ORS using similar batch jobs?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!