DATAFILTER subcommand (TCM MODEL command)
The DATAFILTER
subcommand defines filter criteria for specifying which
dimension values are included in the analysis. It applies only to multidimensional data. The
specified filter applies to all time series that are included in the analysis. For example,
if there are dimension fields for region and brand,
then you might choose to limit the analysis to particular regions but include all brands for
those regions.
- DIMVALUES
- The
DIMVALUES
keyword specifies the filter. The form of the specification for a particular dimension field isdimField(INCLUDE|EXCLUDE=dimValueList)
, wheredimField
is the name of the field anddimValueList
is a list of values for that field.- The
INCLUDE
orEXCLUDE
keyword is required. INCLUDE
specifies a list of values, from the associated dimension field, to include.EXCLUDE
specifies a list of values, from the associated dimension field, to exclude.- You can specify included or excluded values for one or more dimension fields. For
dimension fields that are not specified on
DIMVALUES
, all values of the associated field are included. - Fields that are specified on the
DIMVALUES
keyword do not supportALL
andTO
. - String values do not need to be quoted, unless the string contains apostrophes or quotation marks. If the string contains apostrophes or single quotes, then enclose the string in double quotes. If the string contains double quotes, then enclose the string in single quotes.
- The