MAPPINGS subcommand (SAVETM1 command)

The required MAPPINGS subcommand defines the mappings from the fields in the active dataset to the dimensions and measures in the specified IBM® Cognos® TM1® cube.

  • The MEASURE_FIELDS keyword is required.
  • For each regular dimension in the cube, you must either map a field in the active dataset to the dimension or specify a slice for the dimension.
MEASURE_FIELDS
Required keyword that specifies the mappings from fields in the active dataset to elements in the measure dimension of the cube.
  • The keyword is followed by an equals sign (=) and a list of fields.
  • The form of a field specification is fieldname (MAPTO='element name' NEW={YES | NO}), where fieldname is the name of a field in the active dataset and 'element name' is the name of the element in the measure dimension that it is mapped to, enclosed in quotation marks. The NEW keyword specifies whether the element is a new element in the measure dimension: YES specifies a new element, NO specifies an existing element.
    Note:
    • Only numeric fields can be specified on the MEASURE_FIELDS keyword.
    • Values that are exported to an existing element in the measure dimension overwrite the associated cells in the TM1 cube.
DIMENSION_FIELDS
Optional keyword that specifies the mappings from fields in the active dataset to regular dimensions in the cube.
  • The keyword is followed by an equals sign (=) and a list of fields.
  • The form of a field specification is fieldname (MAPTO='dimension name'), where fieldname is the name of a field in the active dataset and 'dimension name' is the name of the dimension it is mapped to, enclosed in quotation marks.
    Note:
    • Only string fields can be specified on the DIMENSION_FIELDS keyword.
    • Cases with field values that do not match a leaf element in the specified dimension are not exported. In that regard, you can export only to leaf elements.
SLICES
Optional keyword that specifies slices for one or more regular dimensions. A slice specifies a single leaf element of a dimension so that all exported cases are associated with the specified leaf element.
  • The keyword is followed by an equals sign (=) and a list of fields.
  • The form of a field specification is 'dimension name' (LEAF='element name'), where 'dimension name' is the name of a dimension and 'element name' is the name of the leaf element that defines the slice. Both values must be enclosed in quotation marks.

Example

/MAPPINGS MEASURE_FIELDS=PredictedSales (MAPTO='Predicted Sales' NEW=YES)

          DIMENSION_FIELDS=Region (MAPTO='Region')
                           Product (MAPTO='Product')
                           Month (MAPTO='Month')

          SLICES='Store Type' (LEAF='Department Store')