Live Data Computation Agent – Report

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > Transformation Agents > Data Computation > Parameters >

Live Data Computation Agent – Report

The Live Data Computation Agent has the following report input parameters.

 

Parameter

Description

Source Series

Select one or more source series to update all computed series that use it/them.

 

A computed series 'uses' a source series if its DT_LOGGER_SERIES.SERIES_FUNCTION_INFO sourceSeriesId array contains that other series' LOGGER_SERIES_ID. This 'usage' can be recursive, if the sourceSeriesId array contains a computed series' LOGGER_SERIES_ID.

 

Note: If you select a computed series, the computed series you select is also updated (in addition to the computed series that use it).

 

The source series list includes all source DT_LOGGER_SERIES rows, including computed series, if they are sources to other computed series.

Computed Series

Select one or more computed series to update.

 

Notes:

This list includes ALL active (STATUS_FLAG = 'A') DT_LOGGER_SERIES rows, where SERIES_FUNCTION = 'EarthSoft.Live.Reports.DataComputationAgent' and SERIES_FUNCTION_INFO is not NULL.

ONLY these computed series are updated—not any of their source series, or any of the series that use them.

Start Date

Update computed data >= this date.

 

Includes the whole day.

OR Start Date = most recent computed data date-time + 1 second?

Check this box to use each computed series' most recent DT_LOGGER_DATUM.DATUM_UTC_DT + 1 second as the Start Date, or uncheck it to use the Start Date parameter.

 

Note: If this box is checked, the Start Date may be different for each computed series.

End Date

Update computed data <= this date.

 

Includes the whole day.

SAVE changes to database?

Check this box to save the changes to the database, or uncheck it to display the changes without saving them.

 

This parameter is initially unchecked (False), which will show the changes but not save them to the database. This is useful to check that calculations are being performed correctly prior to adding data to the database.

 

Note: The procedure will be executed even if this parameter is unchecked. But it may use @save_changes_to_database_yn, and only save changes to the database if 'Y'.

UPDATE existing computed data if source data was changed?

Check this box to update existing computed data if source data was changed.

INSERT new computed data if source data was added?

Check this box to insert new computed data if source data was added.

DELETE existing computed data if source data was deleted?

Check this box to delete existing computed data if source data was deleted.

 

Exercise caution if using this option and deleting old source data, e.g. using the Data Expiration Agent.

Details to be included in report output:

Details (old value, new value, etc.) of each datum row that was inserted, updated, or deleted, or

Count of rows that were inserted, updated, or deleted (i.e., @@ROWCOUNT) for each series.

 

 

Note: If running this report as an EIA, the Start Date and/or End Date may be dynamic, e.g. "Today".