Setup Computed Series

<< Click to Display Table of Contents >>

EQuIS 7  >>  Enterprise > EQuIS Live > Agents > Data Computation >

Setup Computed Series

To use the 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.Set DERIVATION equal to a value greater than 0 (e.g., 1). The Data Computation Agent processes the series based on their DERIVATION order: 1, 2, 3, etc.

 

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.DataCompuationAgent.

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