Configuring Dynamic Aggregation for Consumption Analytics
This section outlines the configuration needed for consumption analytics aggregations used with Oracle Utilities Analytics Visualization.
Consumption analytics leverage data generated through dynamic aggregation, and requires configuration of the following objects:
-
Data Sources
-
Aggregator Measuring Component Types
-
Aggregation Groups
-
Measuring Component Sets
Refer to Dynamic Aggregation for more information about configuring dynamic aggregation.
Note: The configuration outlined below is based on data in the demonstration database. This sample configuration uses Electric service for Usage by Network Location, Region, and Customer Classification, and Gas service for Unaccounted for Losses.
Data Sources
Create the following data sources, based on the Measurements from US Service Points (D1-DataSourceMeasurements) business object:
For Usage by Network Location, Usage by Region, and Usage by Customer Classification (Electric)
Field / Section |
Value |
||||
---|---|---|---|---|---|
Data Source |
CM-E-KWH-60-TRANS |
||||
Description |
Electric kWh 60min Transformer Interval Measurements |
||||
Status |
Active |
||||
Data Source Class |
Measurements from US Service Points |
||||
Interval / Scalar |
Interval |
||||
Sourced Measuring Component Type |
|
For Unaccounted for Losses (Gas)
Field / Section |
Value |
||||
---|---|---|---|---|---|
Data Source |
CM-G-CCF-60-FACIL |
||||
Description |
Gas CCF 60min Facility Interval Measurements |
||||
Status |
Active |
||||
Data Source Class |
Measurements from US Service Points |
||||
Interval / Scalar |
Interval |
||||
Sourced Measuring Component Type |
|
Aggregator Measuring Component Types
Create the following aggregator measuring component types, based on the Dynamic Aggregator - Type (D1-AggregationIntervalType) business object:
For Usage by Network Location, Usage by Region, and Usage by Customer Classification (Electric)
Field / Section |
Value |
||||||
---|---|---|---|---|---|---|---|
Measuring Component Type |
CM-E-I-AGG-KWH-60-TRANS |
||||||
Description |
Electric - Interval - Aggregation - kWh 60min Transformer Load |
||||||
Measuring Component Business Object |
Dynamic Aggregator - Interval (D1-AggregatorInterval) |
||||||
Measurement Business Object |
Aggregation Measurement (D1-AggregationMeasurement) |
||||||
Measuring Component Class |
Aggregator |
||||||
Service Type |
Electric |
||||||
Allow Negative Consumption |
Allowed |
||||||
Consumptive/Subtractive |
Consumptive |
||||||
Interval Size |
01:00:00 |
||||||
Data Source |
Electric kWh 60min Transformer Interval Measurements |
||||||
Value Identifiers |
|
For Unaccounted for Losses (Gas)
Field / Section |
Value |
||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Measuring Component Type |
CM-G-I-AGG-CCF-60-FACIL |
||||||||||||||||||||||||||||||
Description |
Gas - Interval - Aggregation - CCF 60min Downstream |
||||||||||||||||||||||||||||||
Measuring Component Business Object |
Dynamic Aggregator - Interval (D1-AggregatorInterval) |
||||||||||||||||||||||||||||||
Measurement Business Object |
Aggregation Measurement (D1-AggregationMeasurement) |
||||||||||||||||||||||||||||||
Measuring Component Class |
Aggregator |
||||||||||||||||||||||||||||||
Service Type |
Gas |
||||||||||||||||||||||||||||||
Allow Negative Consumption |
Allowed |
||||||||||||||||||||||||||||||
Consumptive/Subtractive |
Consumptive |
||||||||||||||||||||||||||||||
Interval Size |
01:00:00 |
||||||||||||||||||||||||||||||
Data Source |
Gas CCF 60min Facility Interval Measurements |
||||||||||||||||||||||||||||||
Value Identifiers |
|
Aggregation Groups
Create the following aggregation groups based on the Aggregation Group (D1-AggregationGroup) business object:
For Usage by Network Location and Usage by Region (Electric)
Field / Section |
Value |
||||||||
---|---|---|---|---|---|---|---|---|---|
Aggregation Group |
CM-E-CONS-TRANS |
||||||||
Description |
Electric Dynamic Consumption |
||||||||
Status |
Finalized |
||||||||
Aggregation Category |
Analytics |
||||||||
Time Zone |
US Pacific Time |
||||||||
Aggregation Schedule |
|
||||||||
Aggregation Measuring Component Sets |
|
For Usage by Customer Classification (Electric)
Field / Section |
Value |
||||||||
---|---|---|---|---|---|---|---|---|---|
Aggregation Group |
CM-E-CONS-PROF |
||||||||
Description |
Consumption - Profile Class |
||||||||
Status |
Finalized |
||||||||
Aggregation Category |
Analytics |
||||||||
Time Zone |
|||||||||
Aggregation Schedule |
|
||||||||
Aggregation Measuring Component Sets |
|
For Unaccounted for Losses (Gas)
Field / Section |
Value |
||||||||
---|---|---|---|---|---|---|---|---|---|
Aggregation Group |
CM-G-LOSS |
||||||||
Description |
Gas Dynamic Consumption |
||||||||
Status |
Finalized |
||||||||
Aggregation Category |
Analytics |
||||||||
Time Zone |
US Pacific Time |
||||||||
Aggregation Schedule |
|
||||||||
Aggregation Measuring Component Sets |
|
Measuring Component Sets
Create the following measuring component sets based on the Aggregation Foundation Set (D1-AggregationFoundationSet) business object:
For Usage by Network Location and Usage by Region (Electric)
Field / Section |
Value |
||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Measuring Component Set |
CM-E-CONS-TRANS |
||||||||||||||||||||
Status |
Active |
||||||||||||||||||||
Description |
Electric - Consumption - Transformer - Interval |
||||||||||||||||||||
Measuring Component Type |
Electric - Interval - Aggregation - kWh 60min Transformer Load |
||||||||||||||||||||
Aggregation Group |
Electric Dynamic Consumption |
||||||||||||||||||||
Measuring Component Set Class |
Aggregation Foundation |
||||||||||||||||||||
Allow Partial Constituent Aggregation |
Yes |
||||||||||||||||||||
Extract |
Do Not Extract |
||||||||||||||||||||
General Processing |
|||||||||||||||||||||
Criteria Processing |
|
||||||||||||||||||||
Dimensions |
|
||||||||||||||||||||
Criteria |
|
For Usage by Customer Classification (Electric)
Field / Section |
Value |
||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Measuring Component Set |
CM-E-CONS-PROF |
||||||||||||||||||||||||
Status |
Active |
||||||||||||||||||||||||
Description |
Consumption - Profile Class - Interval |
||||||||||||||||||||||||
Measuring Component Type |
Electric - Interval - Aggregation - kWh 60min Transformer Load |
||||||||||||||||||||||||
Aggregation Group |
Consumption - Profile Class |
||||||||||||||||||||||||
Measuring Component Set Class |
Aggregation Foundation |
||||||||||||||||||||||||
Allow Partial Constituent Aggregation |
Yes |
||||||||||||||||||||||||
Extract |
Do Not Extract |
||||||||||||||||||||||||
General Processing |
|
||||||||||||||||||||||||
Criteria Processing |
|||||||||||||||||||||||||
Dimensions |
|
||||||||||||||||||||||||
Criteria |
For Unaccounted for Losses (Gas)
Field / Section |
Value |
||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Measuring Component Set |
CM-G-LOSS |
||||||||||||||||||||
Status |
Active |
||||||||||||||||||||
Description |
Gas - Consumption - Downstream - Interval |
||||||||||||||||||||
Measuring Component Type |
Gas - Interval - Aggregation - CCF 60min Downstream |
||||||||||||||||||||
Aggregation Group |
Gas Dynamic Consumption |
||||||||||||||||||||
Measuring Component Set Class |
Aggregation Foundation |
||||||||||||||||||||
Allow Partial Constituent Aggregation |
Yes |
||||||||||||||||||||
Extract |
Do Not Extract |
||||||||||||||||||||
General Processing |
|||||||||||||||||||||
Criteria Processing |
Non-Individually Managed Formula: TFORM |
||||||||||||||||||||
Dimensions |
|
||||||||||||||||||||
Criteria |
|