TreeFH Transform

image_pdfimage_print

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.

Global element type

The element type for all elements can be set to either numeric or string. To specify the type for each element individually, use the TreePC or TreeNC transforms.

image_pdfimage_print
Was this post helpful?
NoYes (-6 rating, 10 votes)
Loading...