Creating hierarchies with dynamic ranges

With the content of columns of unified mappings you can automatically create hierarchies in the target dimension. This allows to dynamically create hierarchies with the information of the source system.

To create a hierarchy, select the dimension a hierarchy is to be created for. Go to the Unified Data Sources tab in the data area of the dimension. There, go to the Schema tab. Select the column of the source, that contains the parent information. From the Mapping column, select Parent.

When you create a dynamic range, the elements and the hierarchy are added to the dimension.

Note: If the parent and the element have the same ID, the hierarchy has been defined incorrectly and cannot be fully created. The erroneous elements are listed in the log while processing dynamic range. These elements are added to the top level of the dimension.