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*

Procurement Class*

No*

Table

Service Point - MDM

City

No

Table

Service Point - MDM

Postal

No

Table

Usage Subscription

Usage Subscription Type

No

Table (Demo)

Service Point Facility - MDM

Facility ID

No
* Optional

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