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