TreePC Transform

image_pdfimage_print

Related link: Overview of Tree Formats

The TreePC transform (parent-child tree) creates a tree with parent-child relationships, attributes, and weights. 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.

result_treepc

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