Related link: Overview of Tree Formats
The TreeFH (Full Hierarchy tree) transform creates a tree with node names and attributes from a data source, with hierarchical data organized into levels. This transform can be used as the basis for creating a Jedox dimension with a Dimension load. Each line of the data source must contain the full hierarchy information with all parent nodes up to the top level.
An input field is assigned to the data source for each level of the tree. Additionally, the following criteria can be defined for each level, if required:
- Weight (=consolidation factor) of each node to the level above.
- One or more attributes for the node at this level. The attributes have to be defined separately by type “numeric” or “string”.
Fields from the data source or constant inputs can be used as inputs for this.
Additional top element
Fields from the data source or constant inputs can be used as inputs for this. A constant element that is additionally connected to the top level can be defined. This can be used, for example, when loading cubes for values for which no element exists in the Jedox dimension.