Mapping fields to TM1 dimensions

Use the Mapping tab in the Export to TM1 dialog box to map SPSS® Statistics fields to the associated IBM® Cognos® TM1® dimensions and measures. You can map to existing elements in the measure dimension or you can create new elements in the measure dimension of the TM1 cube.

  • For each regular dimension in the specified TM1 cube, you must either map a field in the active dataset to the dimension or specify a slice for the dimension. A slice specifies a single leaf element of a dimension so that all exported cases are associated with the specified leaf element.
  • For a field that is mapped to a regular dimension, 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.
  • Only string fields in the active dataset can be mapped to regular dimensions. Only numeric fields in the active dataset can be mapped to elements in the measure dimension of the cube.
  • Values that are exported to an existing element in the measure dimension overwrite the associated cells in the TM1 cube.

To map an SPSS Statistics field to a regular TM1 dimension or to an existing element in the measure dimension:

  1. Select the SPSS Statistics field from the Fields list.
  2. Select the associated TM1 dimension or measure from the TM1 Dimensions list.
  3. Click Map.

To map an SPSS Statistics field to a new element in the measure dimension:

  1. Select the SPSS Statistics field from the Fields list.
  2. Select the item for the measure dimension from the TM1 Dimensions list.
  3. Click Create New, enter the name of the measure element in the TM1 Measure Name dialog and click OK.

To specify a slice for a regular dimension:

  1. Select the dimension from the TM1 Dimensions list.
  2. Click Slice on.
  3. In the Select Leaf Member dialog, select the element that specifies the slice and then click OK. You can search for a specific element by entering a search string in the Find text box and clicking Find Next. A match is found if any part of an element matches the search string.
    • Spaces included in the search string are included in the search.
    • Searches are not case-sensitive.
    • The asterisk (*) is treated as any other character and does not indicate a wildcard search.

You can remove a mapping definition by selecting the mapped item from the TM1 Dimensions list and clicking Unmap. You can delete the specification of a new measure by selecting the measure from the TM1 Dimensions list and clicking Delete.