To access the extraction settings, click [Extraction Settings] in the main window of the component. The window “Hierarchy Settings” opens.
Extraction Settings #
- ParentChild: The Hierarchy is represented in the SAP parent-child format, see Output Formats: ParentChild. Example:
- Natural: The SAP parent-child Hierarchy is transformed into a regular hierarchy, see Output Formats: Natural. Example:
- ParentChildWithNodeNames: The Hierarchy is represented in a reduced SAP parent-child format that only includes single nodes and their parent, see Output Formats: ParentChildWithNodeNames. Example:
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.
All texts of InfoObjects that have language dependent texts will be retrieved in the language that the SAP source connection uses. If no texts exist, the result does not contain any texts for entries of that InfoObject.
Natural Settings #
Note: the subsection Natural Settings is only active, when the Representation is set to Natural.
Defines the maximum number of levels. The following example shows a Hierarchy with four levels.
Returns only the leaves as data records.
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.
Description texts for levels:
Sets the output field LevelTextN for each field LevelN containing the text based on the system language settings.
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.