Mappings in TM1Connect allow you to further refine and tailor the output to your applications. With mappings, you can:

Rename columns

Remove columns

Include meta data

Change the data type

Format dates and Boolean values

Apply formulas to columns

Change column indexing method


In order to use mappings, you must select the Enable Mappings check box. If this option is not set, the default mappings (one column for each row dimension, and one column for each measure dimension member) will be used.


Mappings Screen Overview


The image below shows the overview of the mapping properties screen:


Mapping Properties


Available Fields Section

This section displays all of the information that is available in TM1Connect when creating a view. Any item in this field list can be included as a column in the results, including fields such as Cube Name, Row Count, Title Dimension members and attributes, etc. This section contains a tree that you can expand to locate the value

Column Mapping Section

This section displays the name of the column that will be available to applications and the formula that defines how the column is sourced, the data type of the column, and as well as buttons for removing columns or specifying data conversion settings. In this section there are five columns displayed:

Column Name        - Name of the column users/applications will see

Formula                - Formula which defines the source of data for the field

Data Type        - Data Type to return the values as

Remove                - Remove mapping from list

Advanced        - Specify advanced properties for mapping, such as data conversions

Mapping Columns