- SERIES_SPEC (input_series)
- Primary input is an input source containing univariate or multivariate series instances. These are the series to unnormalize, which were previously normalized using TD_SEASONALNORMALIZE. Input payload content type can be REAL or MUTLIVAR_REAL. The primary input specification must include the INTERVAL parameter that reflects the same INTERVAL used in the TD_SEASONALNORMALIZE callused to normalize the series.
- SERIES_SPEC or ART_SPEC
- The secondary input contains a multivariate series instances with fields that are the same as is found in an ARTMETADATA layer, specifically the mean and standard deviation pairs.
SERIES_SPEC references an input source containing multivariate series instances where the fields are the same as in an ARTMETADATA layer, specifically the mean and standard deviation pairs. There is one pair for each payload-field found in the primary input. Mean corresponding to field n of primary input payload, and standard deviation corresponds to field n of primary input payload.
ART_SPEC references an analytical result table (ART) that was created using TD_SEASONALNORMALIZE. The ART_SPEC must have TABLE_NAME, LAYER(ARTMETADATA), PAYLOAD(FIELDS(mean:std pairs, …), and CONTENT(MULTIVAR_REAL)). Do not use any other ART_SPEC parameters.ART_SPEC( TABLE_NAME( [database-name .] table-name ), LAYER(ARTMETADATA), PAYLOAD(FIELDS(,mean:std pairs, …),CONTENT(MULTIVAR_REAL))
See ART Specifications.
- FUNC_PARAMS
-
Name Data Type Description FIELDS Integer list [Optional] An integer-list identifying the fields by position number that the function is to unnormalize. The position list corresponds to the PAYLOAD-FIELDS specified in the primary input. The first field is identified by 1, the second by 2, and so on. Separate the position values with commas. If FIELDS is specified, then only the payload fields in the list are unnormalized. If FIELDS is not specified, then all payload fields of the first input are to be unnormalized. For example, If the primary input has PAYLOAD(FIELDS(a,b,c),…) and FUNC_PARAMS has FIELDS(2), then only field b, the second field, is unnormalized.
The integer values must be positive. The payload field indices start at 1.
- INPUT_FMT
- Mandatory specification. The INPUT_MODE parameter has the following options:
- ONE2ONE: Both the primary and secondary series specifications include a WHERE filter clause identifying one series instance to serve as the input series for the mathematical operation.
- MANY2ONE: The primary input SERIES_SPEC references MANY series instances. The secondary input SERIES_SPEC includes a WHERE filter clause identifying a single series instance. When applying the mathematical operation, the secondary input single series is reused as many times as necessary to match the number of series instances found in the primary input.
- MATCH: A series instance residing in the primary input whose SERIES_ID matches the SERIES_ID of a series instance in the secondary input, has the mathematical operation applied to produce a result series. For those instances in one input who have no corresponding SERIES_ID partner in the other input, the series is skipped over.
- OUTPUT_FMT
- [Optional] The INDEX_STYLE of the output format. Options are NUMERICAL_SEQUENCE and FLOW_THROUGH. The default is NUMERICAL_SEQUENCE.