TreeNC Transform

Related link: Overview of Tree Formats

N and C stand for base element (N) and consolidated element (C). This transform creates a tree with attributes and qualifiers from a so-called NC format. TreeNC is predominantly used in Jedox to create dimensions from exported flat files in NC format from data sources such as Jedox OLAP Server, Alea, or TM1.

The columns of the NC format have to be assigned to input fields of the source or to a constant value:

Element type Possible values:
  • "N": base element of type numeric
  • "S": base element of type string
  • "C": consolidated element. All subsequent rows with empty element type are children of this element.
  • " " (empty): child element of the last preceding element with type "C". The element has to be defined additionally in a separate row with type "N" or "S".
Element name Column containing the name of the element.
Weight Column containing the weighting factor (only for rows with empty element type)

For each 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.

A data preview displays if the columns are correctly defined. Then the load can be generated in order to create the dimension with hierarchies in Jedox.

Example:

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 June 5, 2023