AutoCollect - Creating User Defined DELTA Rowsets › Manipulating Delta Rowsets - User Created Delta Rowsets

Manipulating Delta Rowsets - User Created Delta Rowsets

The AutoCollect process recognizes that there is a need to manipulate the data stored in the Delta tables. In most cases, you want to do this manipulation based on a given rowset or group of rowsets.

There are three AUTOCOLL options to perform basic Delta rowset manipulation functions. The rowset functions are the following:

• SUMMARY is used to combine Delta rowsets into a single new Summary rowset for comparison purposes. These rowsets can be used to summarize smaller delta periods into larger delta periods. For example, daily deltas into weekly deltas or weekly delta into monthly deltas.
• BASELINE is used to combine Delta rowsets into a given new rowset and then divide the counter columns by the number of input rowsets to get a calculated baseline. These baseline rowsets could be used for comparison purposes such as comparing an average week from one year to an average week to another year.
• AVGPERF is used to create special comparison rowsets. These rowsets are built by adding selected rowsets together and then dividing by the total duration hours to get average performance per single duration hour. These rowsets are used to compare the performance of two periods where the duration of the periods is very different. For example, the average hourly performance of a selected week to the average hourly performance of a selected month.

As stated, you can use the DELTARPT function to help decide what rowsets are available for SUMMARY, BASELINE, or AVGPERF processing.

Once a user created Delta rowset is generated by the Summary/AVGPERF/BASELINE options, the rowset is available for further user Delta creation processing. For example, you create several weekly Summary rowsets from the matching seven days of daily (Interval) rowsets. These Summary rowsets are now available to be input to another four-week Summary rowset or a Baseline rowset.