Aggregation
IEE uses aggregation in conjunction with formula channels to run a task that combines interval data from multiple channels. Before running an aggregation task, you must configure the following:
-
Create formula channels as independent configuration objects. For more information, see UCE formulas.
-
Define task-specific parameters. For more information, see Task scheduler.
After these parameters are configured, you can generate reports, graphs, and exports from the aggregated data.
Note: You can also access Aggregation from the Meter Data Management Workbench.
Use the following procedure to configure a task template:
-
Go to System Operations > Task Management > Task Templates.
-
Use the dropdown menu to select the Task Type and Task Template. (Click Add to create a new task template. For more information, see Adding task templates.)
-
Configure the Task specific parameters. These parameters are defined after step 5 of this procedure.
-
Configure the Common task template parameters. For more information, see Task template parameters.
-
Click Save.
Task Specific Parameters:
Select Time Span
Defines the Time Span.
-
Select the Time Period from the dropdown menu and select the appropriate date and time criteria.
-
(Optional) Click the
Reading Groups button to view and select dates available for a particular meter reading group.
A reading group identifies a group of physical readings that IEE imported, collected, or edited at the same time and processed as a set. In IEE versions 7.0 SP2 and later, a reading group can also identify a group of readings that were exported at the same time. Reading group selection allows you to select time periods that correspond to existing data chunks without having to enter them manually.
You will see the Reading Groups button in many sections of IEE, including interactive graphing, reports, and exports.
To select reading groups
A reading group identifies a group of readings that are imported, collected, edited, or exported at the same time and processed as a set. Reading groups can include interval readings, register readings, or both.
You can select reading groups based on import (for pre-billing data) and export (for post-billing data). When you have selected a reading group and click OK, the reading group values populate the screen you are working in.
Other types of reading groups, such as archive reading groups, may exist in IEE, but they are not available in this dialog.
To select reading groups:
-
In the window or dialog you are working in, click the Reading Groups button or link.
-
Enter a Service Point ID or click Search to search for a service point.
-
Enter a service point Channel Number.
-
Optional: From the Show dropdown menu, select a filter:
-
All. Determines whether to show all reading groups.
-
Import. Determines whether to show only import reading groups. Import reading groups are created when data is imported into IEE, created by the estimation process, or created through the editing process.
-
Export. Determines whether to show only export reading groups. Export reading groups are created by IEE export tasks, including the AMI Billing Export.
-
Click Find Groups. All groups that contain this service point and match the Show filter appear in a table:
-
Received/Exported. Defines the date and time IEE received the data for imports or exported the data for exports. If you have not filtered the list to show only imports or exports, refer to the Creation Method column. An asterisk indicates that the external system that received the exported data has confirmed that it has received and used the data. Show Version Confirmation Controls must be enabled in System Administration > System Settings > System Behavior Settings for this asterisk to appear.
-
Creation Method. Describes the method that created the reading group, such as manual validation or an XML import or export.
-
Start Date. Defines the date and time of the earliest read in the group.
-
End Date. Defines the date and time of the latest read in the group.
-
Calculated. Describes the date and time the billing determinants were calculated. Applies to export groups only.
-
Significance. Describes the reason the readings were exported, such as Billing or Load Research. Applies to export groups only.
-
Click a row to select it, and then select the data version to use:
-
Current Version. Defines the current reading values in the database.
-
Received/Exported. Defines the reading values at the time IEE imported or exported it.
-
Calculated Data. Defines the reading values at the time IEE calculated the billing determinants.
-
Click OK.
-
(Optional) Click the
Schedule Dates button to select a time of use schedule.
The Schedule Dates button allows you to select a time period corresponding to a specific entity. This option is generally used for running a report task that matches the date and time range of a particular data export (usually for billing purposes). When you click the Schedule Dates button, the Schedule Dates dialog displays.
To configure the schedule parameters:
-
Use the Schedule dropdown menu to select a schedule.
-
Select the Task Template to apply.
-
Select the Entity Type.
You can use the Search Utility to locate the entity type ID.
-
The start date and end date selected on the main screen are then populated in this dialog.
Time Zone
Defines the time zone IEE uses for the service point. Select the time zone if it is different from the default shown.
Only Aggregate Channels with these Statuses
Defines the validation statuses to include in channel aggregation. Select the checkboxes to limit the aggregated data to only those values with particular validation statuses. IEE includes three options, Billing, Load Research, and Other, and you can define validation statuses for each option. Clear the checkboxes to aggregate channels with all validation statuses.
Ignore validation status conditions for register channel contributors
Defines whether the exporting of register channels or formula channels with register channel contributors depend on the validation status condition of the register channel data. When the checkbox is selected, validation status conditions of the register channel data do not affect whether or not the export proceeds. When the checkbox is cleared, IEE handles validation status conditions of the register channel data the same way that it handles interval channel data.
Force Complete
Determines if the aggregation is able to run with partial or no data. Select True to allow the aggregation to run with partial or no data. Select False to force the aggregation task to check for available data before aggregating.
Log Empty Contributors
Determines whether the Aggregation task logs empty contributors or not. By default, the setting is not enabled to improve performance. Logging empty contributors can be time consuming; for best results, minimize the use of logging.