Mapping dimension elements
To import structures and data into the OLAP database, you must copy the source elements that you have selected in the mappings into the dimension or map them to the dimension elements. Thus, you create the hierarchical structure of the dimension, specify the weighting of the elements and assign access permissions. The source elements selected in the mappings are located on the Unified Data Sources tab in the data area of the target dimension.
To display the data range of a dimension, click the dimension in the tree. In the data range of the mapping, you see the dimension on the left and the Unified Data Sources tab on the right. The dimension table contains the elements of the dimension and their hierarchical structure.
Since you specify for each business entity separately, which elements are imported, there is a separate section for each business entity on the Unified Data Sources 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 entities one by one and add them to the dimension to import them.
Tab | Description |
---|---|
Data | Here, you see the source elements of the selected business entity: |
Source elements that you have not mapped or copied. | |
Source elements that you have copied to the element list. | |
Source elements that you have mapped to a different element of the element list. | |
Source elements that have been copied into the element list by a dynamic range. | |
Only show unmapped elements | Enable the check box Only show unmapped elements to show elements that you have not yet mapped or copied. |
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. Here you may specify, whether a column of the source table is to be used as parent. |
Dynamic ranges | Here, you create dynamic filters for an element selection, which may be stored and re-applied to the modified source database. |