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
Measuring Component Type
Value Identifier Type
Measuring Component Types for measuring components to be aggregated
Measurement
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
Measuring Component Type
Value Identifier Type
Measuring Component Types for measuring components to be aggregated
Measurement
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
Value Identifier Type
Short Hand Description
Unit of Measure
Measurement
kWh
Kilowatt-Hours
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
Value Identifier Type
Short Hand Description
Unit of Measure
SQI
Value Calculation Method
Measurement
CCF
100 Cubic Feet (Gas)
Sum
Value 01
Count
Count
Count
Value 02
Average
100 Cubic Feet (Gas)
Average
Average
Value 03
Min
100 Cubic Feet (Gas)
Minimum
Min
Value 04
Max
100 Cubic Feet (Gas)
Maximum
Max
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 Schedule Type: Defined Lag
• Aggregation Cut-Off Time: 0:00:00
• Aggregation Horizon: 24:00:00
• Aggregation Lag: 48:00:00
Aggregation Measuring Component Sets
Sequence
Measuring Component Set
Initiation Method
Measuring Component Set Class
10
Electric - Consumption - Transformer - Interval
Manual
Aggregation Foundation
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 Schedule Type: Defined Lag
• Aggregation Cut-Off Time: 0:00:00
• Aggregation Horizon: 24:00:00
• Aggregation Lag: 48:00:00
Aggregation Measuring Component Sets
Sequence
Measuring Component Set
Initiation Method
Measuring Component Set Class
10
Consumption - Profile Class - Interval
Manual
Aggregation Foundation
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 Schedule Type: Defined Lag
• Aggregation Cut-Off Time: 0:00:00
• Aggregation Horizon: 24:00:00
• Aggregation Lag: 48:00:00
Aggregation Measuring Component Sets
Sequence
Measuring Component Set
Initiation Method
Measuring Component Set Class
10
Gas - Consumption - Downstream - Interval
Automatic
Aggregation Foundation
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
• Non-Individually Managed Formula: TFORM
Dimensions
Source Type
Source Entity
Column/Type
Represent Missing Data
Table
Service Point - MDM
City
No
Table
Service Point - MDM
Postal
No
Table (Demo)
Service Point Facility - MDM
Facility ID
No
Table (Demo)
Service Point Facility - MDM
Facility Relationship Type
No
Criteria
• Criteria Name: TFORM
• Source Type: Table (Demo)
• Source Entity: Service Point Facility - MDM
• Column/Type: Facility Relationship Type
• Criteria Type: Include
• Value: Commodity Distribution
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
• Sequence: 10
• Initiation Method: Manual
• Imported from External Source: No
Criteria Processing
Dimensions
Source Type
Source Entity
Column/Type
Represent Missing Data
Characteristic 
Usage Subscription Characteristics
Usage Subscription ID Characteristic Type    
No
Table
Service Point - MDM
City
No
Table
Service Point - MDM
Postal
No
Table (Demo)
Service Point Facility - MDM
Facility ID
No
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
Source Type
Source Entity
Column/Type
Represent Missing Data
Table
Service Point - MDM
City
No
Table
Service Point - MDM
Postal
No
Table (Demo)
Service Point Facility - MDM
Facility ID
No
Table (Demo)
Service Point Facility - MDM
Facility Relationship Type
No
Criteria
• Criteria Name: TFORM
• Source Type: Table (Demo)
• Source Entity: Service Point Facility - MDM
• Column/Type: Facility Relationship Type
• Criteria Type: Include
• Value: Commodity Distribution