TD_GENSERIES4FORMULA Function | Teradata Vantage - TD_GENSERIES4FORMULA - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

TD_GENSERIES4FORMULA allows you to define and apply a formula to generate a time series. This function has many use cases, including the ability to generate a series that is subtracted from a non-stationary series to make it stationary, and to estimate beyond the sample data points.

The following procedure is an example of how to use TD_GENSERIES4FORMULA:
  1. Determine that the series to be modeled includes a trend.
  2. Use TD_LINEAR_REGR to curve fit the trend.
  3. Use the coefficients computed by TD_LINEAR_TREND, assemble a FORMULA and use TD_GENSERIES4FORMULA to generate a trend series.
  4. Use TD_BINARYSERIESOP to subtract the generated trend from the original series.