Live Data Computation Agent – Setup Computed Series

<< Click to Display Table of Contents >>

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

Live Data Computation Agent – Setup Computed Series

To use the Live Data Computation Agent to produce a computed data series, follow the steps below:

1.Create a new series in the DT_LOGGER_SERIES table.

a.An existing LOGGER_ID can be used, or create a new logger in DT_LOGGER.

b.Make sure to execute the equis.get_ids stored procedure to get a new LOGGER_SERIES_ID, or create the series manually (DT_LOGGER_SERIES row) in EQuIS Professional.

In DT_LOGGER_SERIES...

2.Set SERIES_NAME, SERIES_DESC, and SERIES_UNIT as desired.

3.The Data Computation Agent processes the series based on their DERIVATION order, where 0 = raw/source data. Set DERIVATION equal to a value greater than 0 (e.g., 1). See the table below for more detail.

 

Derivation

Description

NULL or 0

The series contains source/raw data. (The Data Computation Agent does NOT process these series.)

1

The series is dependent on one or more series with derivation equal to NULL or 0.

2

The series is dependent on one or more series with derivation equal to 1.

...


N

The series is dependent on one or more series with derivation equal to N - 1.

 

4.Set SERIES_FUNCTION to EarthSoft.Live.Reports.DataComputationAgent.

5.Set SERIES_FUNCTION_INFO to include one or more SERIES_FUNCTION_INFO parameters.