Analytics Configuration

This section describes functionality provided for integrating with Oracle Utilities Analytics (OUA).

  • Customer Analytics Configuration Portal

    Oracle Utilities Customer to Meter provides a Customer Analytics Configuration portal that holds information on the customer analytics configuration activities. This portal provides a summary of how much configuration has been set up, and also provides links and guidelines for the areas that need configuration, at the minimum, to successfully extract data from Oracle Utilities Customer Care and Billing to OUA. The following provides more information about this functionality.

    1. Customer Analytics Configuration Details – These data load parameters are used to extract, load, and transform data from Oracle Utilities Customer Care and Billing to Oracle Utilities Analytics. These parameters are used to identify and/or filter data when loading them into the data warehouse. Refer to the Oracle Utilities Customer Care and Billing section in the Configuring Oracle Utilities Analytics chapter of the Oracle Utilities Analytics Administration Guide for detailed information on each extract parameter.

    2. Bucket Configuration List – This is a summary of the bucket configurations that are needed to classify and group extracted data within Oracle Utilities Analytics. The bucket configurations provide the ability to readily report and analyze data by buckets, or groups. Refer to the Oracle Utilities Customer Care and Billing section in the Configuring Oracle Utilities Analytics chapter of the Oracle Utilities Analytics Administration Guide for detailed information on each bucket configuration supported by Oracle Utilities Customer Care and Billing.

  • Characteristic Mapping

    Oracle Utilities Customer Care and Billing has identified the objects for which characteristic extraction is supported. This includes mapping the source characteristic entity to thetarget dimension, and defining which target columns are allowed to be mapped for which target dimension. The following table shows the supported mapping.

Object

Supported Target Dimension

Supported Target Columns

Account Characteristic

Account Dimension

User Defined Fields 6 - 15

Person Characteristic

Person Dimension

User Defined Fields 1 - 6

Premise Characteristic

Premise Dimension

User Defined Fields 6 - 18

Premise Characteristic

Address Dimension

User Defined Fields 7 - 16

Service Agreement Characteristic

Service Agreement Dimension

User Defined Fields 9 - 19

Meter Analytics Configuration Portal

The Meter Analytics Configuration portal holds information on the meter data analytics configuration activities. This portal provides a summary of how much configuration has been set up, and also provides links and guidelines for the areas that need configuration, at the minimum, to successfully extract data from Oracle Utilities Meter Data Management to OUA. The following provides more information about this functionality.

  • Analytics - Oriented Master Configuration: These data load parameters are used to extract, load, and transform data from Oracle Utilities Meter Data Management to Oracle Utilities Analytics. They are used to identify and/or filter data when loading them into the data warehouse. Refer to the Oracle Utilities Meter Data Management section in the Configuring Oracle Utilities Analytics chapter of the Oracle Utilities Analytics Administration Guide for detailed information on each extract parameter

  • Analytics - Oriented Extendable Lookup List: The meter data analytics related Extendable Lookup Business Objects are listed in this section. It provides a navigation link to the extendable Lookup Maintenance portal where the lookup values can be configured. Refer to the Oracle Utilities Meter Data Management section in the Configuring Oracle Utilities Analytics chapter of the Oracle Utilities Analytics Administration Guide for detailed information on meter data analytics related extendable lookups.

  • Service Point Configuration List: This lists the service point types within the system and indicates for each whether or not the meter analytics configuration has been setup. It provides a navigation link to the service point type where the necessary configuration can be setup or modified. Refer to the Oracle Utilities Meter Data Management section in the Configuring Oracle Utilities Analytics chapter of the Oracle Utilities Analytics Administration Guide for further information.

Batch Controls

Batch Code

Name / Description

D1-SPSDL

Service Point Snapshot Download

D2-DUGDL

Usage Subscription Usage Group Download

D2-MVREF

Materialized View Refresh

D2-USGDL

Service Point Usage Snapshot Download

D2-UUSDL

SP Unreported Usage Snapshot Download

D2-VEEDL

SP VEE Exception Snapshot Download

References

Refer to the following documentation for more information about Oracle Utilities Analytics:

  • Oracle Utilities Analytics Admin Guide

  • Oracle Utilities Analytics Dashboards for Oracle Utilities Customer Analytics, Revenue Analytics and Credit & Collections Analytics Metric Reference Guide

  • Oracle Utilities Analytics Dashboards for Oracle Utilities Exception Analytics Metric Reference Guide

  • Oracle Utilities Analytics Dashboards for Oracle Utilities Meter Data Analytics Metric Reference Guide

  • Oracle Utilities Extractors and Schema for Oracle Utilities Customer Care and Billing Data Mapping Guide

  • Oracle Utilities Extractors and Schema for Oracle Utilities Meter Data Management Data Mapping Guide