Configuring Timeliness and Quality Aggregation for Use with Oracle Utilities Analytics Visualization

This topic outlines the configuration needed for timeliness and quality aggregations used with Oracle Utilities Analytics Visualization.

Master Configuration

Create a Timeliness Master Configuration, defining the following:

  • Heating Degree Days Factor: A number-based factor that contains heating degree days. These are aggregated and stored on the Measurement Measured Quantity Aggregator.

  • Cooling Degree Days Factor: A number-based factor that contains cooling degree days. These are aggregated and stored on the Measurement Measured Quantity Aggregator.

  • Number of Hours to Consider IMD as Late: The number of hours after which an initial measurement is considered late. 

  • Buckets: Value Identifiers that specify the late buckets used by the Measurement Timeliness Count and Measurement Timeliness Quantity aggregators.

Extendable Lookup: BI Aggregation — Usage Group Mapping

If your implementation makes use of dynamic usage calculation group determination on usage subscriptions (via the Calculation Group Determination Override Algorithm on the usage subscription type, the Rate History collection on the usage subscription, and the Customer Rate Schedule extendable lookup (D2-CCBRateScheduleLookup)), you will need to configure the BI Aggregation Usage Group Mapping extendable lookup (D2-UsageCalculationGroupLookup) with the usage calculation groups you wish to aggregate. If in the future you add new usage calculation groups, you will also need to add those usage calculation groups to this extendable lookup if you want them to be aggregated.

Note that an aggregation measuring component will be created for all dimension combinations and each usage calculation group in the extendable lookup (this is done to alleviate the need to execute the usage group determination algorithm for all usage subscriptions during the dimension scanning process).

Note: Configuring this extendable lookup is required ONLY if using dynamic usage calculation group determination.

Measuring Component Types

Create a master aggregator measuring component type and sub aggregator measuring component types for the four types of aggregators outlined above. Details for each aggregator measuring component type are listed below.

Measurement Measured Quantity Aggregator

  • Measuring Component Type Business Object: Master Measurement Aggregator Type (D2-MasterMsrmtAggregatorType)

  • Measuring Component Business Object: Measurement Measured Quantity Aggregator (D2-MeasuredQuantityAggregator)

  • Measurement Business Object: Measured Quantity Measurement (D2-MeasuredQuantityMsrmt)

  • Value Identifiers (recommended):

Value Identifier Type

Description

Unit of Measure

Measurement

kWh

Kilowatt-Hours

Value 01

Regular kWh

Kilowatt-Hours

Value 02

Estimated kWh

Kilowatt-Hours

Value 03

User-Edited kWh

Kilowatt-Hours

Value 06

Count

Count

Value 07

Heating Degree

Fahrenheit

Value 08

Cooling Degree

Fahrenheit

Value 09

Ave kWh

Kilowatt-Hours

  • Sub Aggregator MC Types (see below):

    • Measurement Quality Count Aggregator Type

    • Measurement Timeliness Count Aggregator Type

    • Measurement Timeliness Quantity Aggregator Type

Measurement Quality Count Aggregator

  • Measuring Component Type Business Object: Sub Measurement Aggregator Type (D2-SubMeasurementAggType)

  • Measuring Component Business Object: Measurement Quality Count Aggregator (D2-MsrmtQualityCountAggregator)

  • Measurement Business Object: Quality Count Measurement (D2-QualityCountMsrmt)

  • Value Identifiers (recommended):

Value Identifier Type

Description

Unit of Measure

Measurement

kWh

Kilowatt-Hours

Value 01

Regular Count

Count

Value 02

Estimated Count

Count

Value 03

User-Edited Count

Count

Value 04

N Meas/No IMD Count

Count

Value 05

No Meas/IMD Exists Count

Count

Value 06

Read Outage Count

Count

Value 07

Read Other Count

Count

Value 08

Missing Count

Count

Measurement Timeliness Count Aggregator

  • Measuring Component Type Business Object: Sub Measurement Aggregator Type (D2-SubMeasurementAggType)

  • Measuring Component Business Object: Measurement Timeliness Count Aggregator (D2-MsrmtTimelinessCountAggr)

  • Measurement Business Object: Timeliness Count Measurement (D2-TimelinessCountMsrmt)

  • Value Identifiers (recommended):

Value Identifier Type

Description

Unit of Measure

Measurement

kWh

Kilowatt-Hours

Value 01

On Time Count

Count

Value 02

Late Count

Count

Value 03

Very Late Count

Count

Value 04

Very, Very Late Count

Count

Value 05

Missing Count

Count

Measurement Timeliness Quantity Aggregator

  • Measuring Component Type Business Object: Sub Measurement Aggregator Type(D2-SubMeasurementAggType)

  • Measuring Component Business Object: Measurement Timeliness Quantity Aggregator (D2-MsrmtTimelinessQuantityAggr)

  • Measurement Business Object: Timeliness Quantity Measurement (D2-TimelinessQuantityMsrmt)

  • Value Identifiers (recommended):

Value Identifier Type

Description

Unit of Measure

Measurement

kWh

Kilowatt-Hours

Value 01

On Time kWh

Kilowatt-Hours

Value 02

Late kWh

Kilowatt-Hours

Value 03

Very Late kWh

Kilowatt-Hours

Value 04

Very, Very Late kWh

Kilowatt-Hours

Activity Type

Create a Measurement Quantity Scanner activity type, based on the following business objects:

  • Business Object: Measurement Quantity Scanner Type

  • Related Transaction Business Object: Measurement Quantity Scanner