Step 4 - Create the unified mappings
Here you create general mappings of source tables to target dimensions. For each table in a source database a mapping is proposed in the column ID of the unified mapping.
If you expand the view of a mapping, you see the business units that contain these tables. In the Description column, you find the description of the table. With the help of the description, you may check, whether tables with the same Id have the same function in all business entities. If the function and the content are not Identical, a unified mapping does not make sense.
To use all business entities in a mapping, select the check box of the mapping. To exclude a business entity from the mapping, clear the check box of the business entity in the mapping.
In the column Target dimension select the dimension, into which you import the data and the structures of the table later on.
| Column | Description |
|---|---|
| Id of the unified mapping | For each table used in at least one business entity of the source database, a mapping will be proposed. Only one mapping will be created for tables of the same name in several business entities (unified mapping). Use the Description column to check, whether the table has the same function in all source databases. You may exclude individual business entities. Select the check box next to the mapping ID to create the mapping. |
| Description | Specify the description of the mapping. The description of one of the tables in the source database will be proposed. Use the description to check, whether all business entities in tables of the same name store the same contents. |
| Use default mapping |
Select the check box to add all elements of the source table as preselection to the element list. This is useful, if import all elements later on. Thus, you will not require to select the elements separately for the import. The elements are available on the Unified Data Sources tab in the target dimension. If you select the option Use default mapping, a dynamic range will be created for the mapping, which contains all source elements. Filter: ID LIKE %. |
| Target dimension | Select the dimension, into which you import the data and the structures of the table later on. The dimension must exist in the tree of Designer. |
| Use default mapping (Target dimension) | Select the check box to add elements of the source table to the target dimension. This is only useful, if the check box Use default mapping is also selected for the mapping. If you select the option Use default mapping, a dynamic range will be created for the target dimension, which contains all source elements. Filter: ID LIKE %. |