TD_SIMPLEEXP Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-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.