Related link: Overview of Tree Formats
The TreePC transform (parent-child tree) creates a tabular representation of parent-child relationships. This transform is used mainly for creating dimensions in Jedox.
The columns of the parent-child format have to be assigned to input fields of the source or to a constant value:
| Parent element | Column containing the parent element. If the parent is a constant (e.g. "All Regions") you must switch from reference to constant. |
| Child element | Column containing the child element |
| Weight | Column containing the weighting factor |
For each child element, several attributes can be defined in a separate table, each with a name, an element type (numeric or string), and an assignment to an input field of the source.
Note: when the input is coming dynamically from the Source or Transform, but the "Field name" is left empty, the name of the source column/ function is used for the Field name. When the target is manually defined as constant, then the name "constant" is chosen instead of the value from the "Input" field. Adding more than one constant column results in error, because there would be two columns with the name "constant."
Updated July 8, 2024