Selecting source elements for import

For each mapping of source tables to OLAP dimensions you must specify, which source elements to import into the dimensions later. When you specify the source elements, you do not yet create a hierarchical structure, but a common list for the source elements of all business units of the mapping. The source elements that you select for a mapping, may be imported later on the Unified Data Sources tab in the data area of the target dimension.

To create the list of the source elements for the import, click the mapping in the tree view. In the data area of the mapping, you see the element table on the left and the Source tab on the right. The element table contains the elements that will later be available in the target dimension for import. In the Source tab, the source elements of the source table are displayed.

Since you specify separately for each mapping of a business entity, which elements are imported, there is a separate section for each business entity on the Source tab containing the tabs Data, Schema and Dynamic Ranges. Only the range of one business entity is displayed.

To show the source elements of a hidden business entity, click the bar with the name of the business entity. Select the source elements of the business units one by one and create a common selection of elements to import later on.

Tab Description
Data Here, you see the source elements of the selected business entity:
unmapped elements Source elements that have not been mapped or copied.
copied elements Source elements that you have copied to the element list.
mapped elements Source elements that you have mapped to a different element of the element list.
elements copied by a dynamic range Source elements that have been copied into the element list by a dynamic range.
Schema Here, you map the columns of the source table (Column) to the columns of the target dimension (Mapping). Thereby, you determine, how the values of the source elements will be processed.
Dynamic ranges Here, you create dynamic filters for an element selection, which may be stored and re-applied to the modified source database.