How Cognos TM1 Performance Modeler maps the data

When you import data, IBM Cognos® TM1 Performance Modeler maps your data depending on the type of data that you are importing. During the import, you can override any of the choices that are made about how to map your data.

If you import a Cognos list report or package, the model that was defined in the source is used. Data from other data sources is mapped in the following ways by default:

• The first column in the source file, and the measures appear in a crosstab. The other columns are available as dimensions in the overview area.
• Columns of text are added as dimensions.
• Columns of numbers are added as measures if they are values. For example, a column called Revenue can be interpreted as a measure, and a column called Telephone number can be interpreted as an attribute.