TD_SIMPLEEXP Syntax Elements - 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
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
SERIES_SPEC
Input source containing the univariate series instances to be processed by the function. Input values are REAL.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
FORECAST_PERIODS Integer Number of periods to forecast. It is an integer between 1 to 32000.
FORECASTING_STARTING_VALUE Enum, String [Optional] Starting value for the interval. Options are FIRST or MEAN. Default is FIRST.
ALPHA FLOAT [Optional] If present, this value is used in the equation to perform the forecasting. If not present, then the value of ALPHA is set to a value of 1.
PREDICTION_INTERVALS Enum, String The confidence level for the prediction, such that 85 means 85% confidence.
  • NONE
  • 85
  • 90
  • BOTH

Default is BOTH 85 and 90.

FIT_METRICS Integer [Optional] Indicator to generate the secondary result set that contains the model metadata statistics. A value of 1 means generate the secondary result set. A value of 0 means do not generate the secondary result set. The default is 0.
RESIDUALS Integer [Optional] Indicator to generate the tertiary result set that contains the model residuals. A value of 1 means generate the tertiary result set. A value of 0 means do not generate the tertiary result set. The default value is 0.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
[Optional] Specify the INDEX_STYLE of the output format. Options are NUMERICAL_SEQUENCE and FLOW_THROUGH. The default is FLOW_THROUGH.