OU Analytics For Oracle Realtime Scheduler (ORS) Reporting On Planned Shifts And Work Requires Custom Star Schema (Doc ID 2093851.1)

Last updated on JANUARY 04, 2016

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.

Goal

We will be setting up Analytics for 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?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms