To access the extraction settings, click [Extraction Settings] in the main window of the component. The window “Hierarchy Settings” opens.
Hierarchies-Settings

Extraction Settings #

Representation:

Remove Leading Zeros:
If this option is active, all leading zeros in the column NodeName of the leaves are removed. NodeName can then be used in a JOIN-condition with the corresponding Dimension-Key of a BW Cube extraction.
The conversion works for compound InfoObjects, too. Example: 0CO_AREA (1000) and 0COSTCENTER (0000003100) become 1000/3100.

Fetch description texts:
Sets the node text in the column NodeText based on the system language settings.

Natural Settings #

Note: the subsection Natural Settings is only active, when the Representation is set to Natural.

Level Count:
Defines the maximum number of levels. The following example shows a hierarchy with four levels.
Hierarchy-Parent-Child-Natural

Leaves only:
Returns only the leaves as data records.
Hierarchy-Leaves-Only

Fill empty levels:
Copies the bottom element of the hierarchy until the last level. The following example depicts the previously shown hierarchy with the activated Repeat Leaves option.
Hierarchy-Parent-Child-Repeat

Description texts for levels:
Sets the output field LevelTextN for each field LevelN containing the text based on the system language settings.
Hierarchy-Description-Texts

Debug #

Enable Debug Logging:
Adds more detailed logs for the Hierarchy component to the extraction logs. Activate Enable Debug Logging only when necessary e.g., upon request of the support team.