Name Mapping
The Name Mapping screen allows you to enable translations for technical and language specific terms to a user friendly format. It is also used for localization of your analyses for user groups speaking different languages.
It is possible to use translation tables from databases or use an excel template and edit it on your local machine.
Note
A name mapping may have a maximum of 200.000 records.
Name Mappings from file
 |
You may download the currently applied Name Mapping information from the Name Mapping page. Details on the file and format can be found below.
Afterwards you can upload the file again using the file drop zone or you can choose a file from your local machine.
Tip
The downloaded name mapping template automatically comes with the name of the tables and columns in your Data Model preloaded on it. To assign the desired name mapping, you only need to edit the TRANSLATION column.
Table Name Mapping
 |
In the table name mapping sheet you define mapping for the table names.
TABLE_NAME: the technical name of the table in the Data Pool which equals the name in the source system if it was not changed
LANGUAGE_KEY: the language to which to translate the table name
TRANSLATION: the human readable table name in the given language
Column Name Mapping
 |
In the column name mapping sheet you define mapping for the column names.
TABLE_NAME: the technical name of the table in the Data Pool which equals the name in the source system if it was not changed
COLUMN_NAME: the technical name of the column in the Data Pool which equals the name in the source system if it was not changed
LANGUAGE_KEY: the language to which to translate the column name
TRANSLATION: the human readable column name in the given language
General Name Mapping
 |
In the general mapping sheet you define mappings for text snippets which can be used in Analyses.
TRANSLATION_KEY: the placeholder translation key
LANGUAGE_KEY: the language to which to translate the snippet
TRANSLATION: the human readable text in the given language
Name Mapping from Data Pool
Table and column name mappings can also be imported from a Data Pool and therefore from dictionary tables of your source system like DD02T and DD03M in SAP.
 |
1. Configure table name mappings
Table name mappings are in table: select the table in the Data Pool that contains the table names
Technical names column: select the column that contains the table's technical names
Pretty names column: select the column that contains the new desired table names
Language key column: select the column that contains language of the new table names
2. Configure column name mappings
Column name mappings are in table: select table that contains the column names
Table names column: select the column that contains the table's technical names
Technical names column: select the column that contains the column's technical names
Pretty names column: select the column that contains the new desired column names
Language key column: select the column that contains language of the new column names
3. Save and apply
Load Mappings from Pool: Load the values from the Data Pool to apply the mapping
Manage existing Name Mapping
 |
On the bottom you can see whether and how many name mappings have been applied. You can delete the loaded mappings by clicking on the Delete Mappings button.