RENAME subcommand (GETTM1 command)

By default, valid IBM® SPSS® Statistics variable names are automatically generated from the dimension names and measure names from the IBM Cognos® TM1® cube view. Use the RENAME subcommand to define SPSS Statistics variable names for a set of TM1 dimension names or names of elements in the measure dimension.

  • Specify each TM1 dimension name or measure element name in quotation marks, followed by the associated SPSS Statistics variable name in parentheses.
  • Variable names must be unique and must conform to variable naming rules. See the topic Variable Names for more information.

Example

/RENAME FIELDS='Business Unit' (Unit) 'Gross Sales' (GrossSales)

In this example, the dimension named Business Unit is renamed to Unit in the active dataset. The element named Gross Sales in the measure dimension is renamed to GrossSales in the active dataset.