Skip to main content

Celonis Product Documentation

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
50727014.png

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
41191386.png

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
41191387.png

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
41191388.png

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.

50727012.png

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
50727013.png

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.