Data tab – importing and mapping elements

The Data tab shows available elements and provides functions for the import to the selected dimension and the mapping of elements from the source to the target structure.

When you move elements with drag and drop from the Data tab into the dimension structure of the left data section you can select the commands Copy or Move to create the selected element in the dimension and Create Mapping... to create a mapping of source and target elements.

These shortcut menu commands are available to work with elements on the Data tab:

Command Description
Insert as Element... Import as child element. A dialog opens for the selection of the target element.
Insert as Element Automatically Import as child element applying the mapping on the Schema tab. The Parent column is used for the hierarchy.
Insert as Element Automatically (without Parents) Import as basic element without applying mappings from the Schema tab.
Map to Element Mapping to an element. A dialog opens for the selection of the target element.
Map to Element Automatically Automatic mapping to an element of the same name or ID.
Remove Mapping Deletion of a mapping.

You can perform these shortcut menu commands with several elements at the same time.

On the Data tab, mappings are displayed with a blue square in front of the mapped element in the key column.

You can clear or select the check box Display Mapped Elements to hide or display mapped elements on the Data tab. The check box is only shown in case of saved profiles for relational data sources.