Licensing Information
Oracle Utilities Analytics Warehouse is a collection of separately licensed products. These products can be broadly classified into two groups:
The following table provides more detailed information about licensed products within each of these groups:
Product Group
Product
Licensing Description
Oracle Utilities Analytics Warehouse Extractors and Schemas
Oracle Utilities Work and Asset Management Extractors and Schema
Oracle Utilities Work and Asset Management Extractors and Schema group is designed to help extract, transform and load data from Oracle Utilities Work and Asset Management application to Oracle Utilities Analytics Warehouse data warehouse.

Load routines in this product are using Oracle Data Integrator and extraction routines that are embedded in the source application itself.

Prerequisites: Oracle Utilities Work and Asset Management
 
For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Utilities Customer Care and Billing Extractors and Schema
This group of extractors and schema products are designed to help extract, transform and load data from respective Oracle Utilities Customer Care and Billing applications to Oracle Utilities Analytics Warehouse data warehouse.

The data extraction and load processes are processes built using Oracle Data Integrator and Oracle GoldenGate.
 
Prerequisites: Oracle Utilities Customer Care and Billing Base, Oracle Data Integrator and Oracle GoldenGate
 
For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Oracle Utilities Network Management Extractors and Schema
Oracle Utilities Network Management Extractors and Schema is designed to help extract, transform and load data from respective Oracle Utilities Network Management System application to Oracle Utilities Analytics Warehouse data warehouse.

The data extraction and load processes are processes built using Oracle Data Integrator and Oracle GoldenGate.

Prerequisites: Oracle Utilities Outage Management Base /or Oracle Utilities Distribution Management Base, Oracle Data Integrator and Oracle GoldenGate

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Utilities Meter Data Management Extractors and Schema
Oracle Utilities Meter Data Management Extractors and Schema is designed to help extract, transform and load data from respective Oracle Utilities Meter Data Management System application to Oracle Utilities Analytics Warehouse data warehouse.

The data extraction and load processes are processes built using Oracle Data Integrator and Oracle GoldenGate.

Prerequisites
: Oracle Utilities Meter Data Management, Oracle Data Integrator
and Oracle GoldenGate

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Oracle Utilities Operational Device Management Extractors and Schema
Oracle Utilities Operational Device Management Extractors and Schema is designed to help extract, transform and load data from respective Oracle Utilities Operational Device Management System application to Oracle Utilities Analytics Warehouse data warehouse.

The data extraction and load processes are processes built using Oracle Data Integrator and Oracle GoldenGate.

Prerequisites
: Oracle Utilities Operational Device Management, Oracle Data Integrator
and Oracle GoldenGate

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Mobile Workforce Management Extractors and Schema
Oracle Mobile Workforce Management Extractors and Schema is designed to help extract, transform and load data from respective Oracle Mobile Workforce Management System application to Oracle Utilities Analytics data warehouse.

The data extraction and load processes are processes built using Oracle Data Integrator and Oracle GoldenGate.

Prerequisites
: Oracle Utilities Mobile Workforce Management Base /or Oracle Real Time Scheduler, Oracle Data Integrator and Oracle GoldenGate

For supported software information, refer to Oracle Utilities Analytics Installation Guide.
Oracle Utilities Analytics Warehouse Dashboards
Oracle Utilities Customer Analytics
This is a group of analytics applications based on Oracle Analytics Server (OAS) and Oracle Utilities Customer Care and Billing Extractors and Schema products.

The application provides a set of Oracle Analytics Server based dashboards that supports several metrics and KPIs related to Customer Care and Billing. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Customer Care and Billing Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications / or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Utilities Revenue Analytics
This is a group of analytics applications based on Oracle Analytics Server (OAS) and Oracle Utilities Customer Care and Billing Extractors and Schema products. This application provides a set of Oracle Analytics Server based dashboards that supports several metrics and KPIs related to Customer Care and Billing. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Customer Care and Billing Extractors and Schema, Oracle Utilities Customer Care and Billing Rating and Billing, Oracle Utilities Customer Care and Billing Credit and Collections and either Oracle Business Intelligence Foundation Suite for Oracle Applications / or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Utilities Credit and Collections Analytics
This is a group of analytics applications based on Oracle Analytics Server (OAS) and Oracle Utilities Customer Care and Billing Extractors and Schema products. This application provides a set of Oracle Analytics Server based dashboards that supports several metrics and KPIs related to Customer Care and Billing. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Customer Care and Billing Extractors and Schema, Oracle Utilities Customer Care and Billing Credit and Collections and either Oracle Business Intelligence Foundation Suite for Oracle Applications / or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Utilities Exception Analytics
This is a group of analytics applications based on Oracle Analytics Server (OAS) and Oracle Utilities Customer Care and Billing Extractors and Schema products.

The application provides a set of Oracle Analytics Server based dashboards that supports several metrics and KPIs related to Customer Care and Billing. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Customer Care and Billing Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications /or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Oracle Utilities Work and Asset Analytics
This is an analytics applications based on Oracle Analytics Server (OAS) and Oracle Utilities Work and Asset Management Extractors and Schema product. This application provides a set of Oracle Analytics Server based dashboards that support several metrics and KPIs related to Work and Asset Management All of the data used in calculating these metrics are hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Work and Asset Management Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications /or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
 
Oracle Utilities Meter Data Analytics
This is an analytics applications based on Oracle Analytics Server (OAS) and Oracle Utilities Meter Data Management Extractors and Schema product. This application provides a set of Oracle Analytics Server based dashboards that support several metrics and KPIs related to Meter Data Management. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Two of the dashboards also use data from Materialized Views hosted on the Oracle Utilities Meter Data Management database.

Prerequisites
: Oracle Utilities Meter Data Management Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications /or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Oracle Utilities Mobile Workforce Analytics
This is an analytics application based on Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Mobile Workforce Management Extractors and Schema product. This application provides a set of Oracle Business Intelligence Enterprise Edition based dashboards that support several metrics and KPIs related to Mobile Workforce Management. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics data warehouse.

Prerequisites
: Oracle Mobile Workforce Management Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications / or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Installation Guide.
 
Oracle Utilities Outage Analytics
This is an analytics application based on Oracle Analytics Server (OAS) and Oracle Utilities Network Management Extractors and Schema product. This application provides a set of Oracle Analytics Server based dashboards that support several metrics and KPIs related to Network Management. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Network Management Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications /or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Oracle Utilities Operational Device Analytics
This is an analytics application based on Oracle Analytics Server (OAS) and Oracle Utilities Operational Device Management Extractors and Schema product. This application provides a set of Oracle Analytics Server based dashboards that support several metrics and KPIs related to Operational Device Management. Data used in calculating these metrics is hosted in the Oracle Utilities Analytics Warehouse data warehouse.

Prerequisites
: Oracle Utilities Operational Device Management Extractors and Schema and either Oracle Business Intelligence Foundation Suite for Oracle Applications or Oracle Business Intelligence Suite Enterprise Edition Plus

For supported software information, refer to Oracle Utilities Analytics Warehouse Installation and Configuration Guide.