Creating mappings

Here, you specify the name and the description of the mapping. In the tree you see the mappings and their description. The descriptions may be edited later. From the drop-down list Mapping type, select the type of the mapping, for example, Scenarios. Selecting the mapping type restricts the selection of source tables. Example: If you select Currencies as the mapping type, only those source tables are displayed that contain currencies. The mapping type cannot be edited later.

Here, you select the source tables of the mapping. In a tree, at the top level, are the business entities that belong to the business group. At the level underneath are the tables of the business entities. Only those source tables are displayed that match the mapping type, for example, currency tables for the mapping type Currencies.

Because tables with the same name may have different functions in the business entities, select the table for each business entity that is to be used in the mapping. You can only select one table as the source per business entity.

Select the check box in the Use default mapping column to insert all elements of the source table as preselection into the element list. This is useful, if you import all elements. If you import all elements, it is not required to select the elements for the import on the Sources tab of the mapping. The elements will be available in the target dimension, when you create the mapping on the Unified data sources tab.

Here, you select the OLAP dimension, into which to import the data and the structures of the source tables. If you later click these dimensions in the tree, you will find the Unified Data Source tab in the data area of the dimension. This tab contains the elements that you select in the data area of the mapping for the import.

Select the check box in the Use default mapping column to add all elements of the source table to the target dimension. This is only useful, if this option is also selected for the source tables.