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 CCB 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
Parent topic