Analytics Configuration

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

  • Customer Analytics Configuration Portal

    Oracle Utilities Customer Care and Billing provides an Analytics Configuration portal that holds information on all the analytics-oriented 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. Analytics-Oriented Master 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