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 is dimField(INCLUDE|EXCLUDE=dimValueList), where dimField is the name of the field and dimValueList is a list of values for that field.
  • The INCLUDE or EXCLUDE 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 support ALL and TO.
  • 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.