In SAP Data Engineer - Data Fabric, particularly when working with hierarchies in query definitions, external hierarchies are used to organize and structure data in a meaningful way for reporting and analysis. External hierarchies are predefined hierarchies that can be integrated into queries, and certain properties of these hierarchies can be adjusted within the query definition to meet specific reporting requirements.
B. Sort direction
The sort direction determines the order in which the hierarchy nodes are displayed in the query results. You can choose to sort the hierarchy in ascending or descending order based on node names, key values, or other attributes. This property is adjustable in the query definition to allow flexibility in how the data is presented to end users.
[: In SAP BW (Business Warehouse) and SAP Data Engineer - Data Fabric, sorting options for hierarchies are available in the query designer under the hierarchy settings., C. Exp to level, The "Exp to level" property allows you to specify the depth to which the hierarchy should be expanded when displayed in the query results. For example, if you set "Exp to level" to 3, the hierarchy will automatically expand to show all nodes up to the third level. This is useful for controlling the granularity of data displayed without requiring manual expansion by the user., Reference: In SAP BW Query Designer, this property is part of the hierarchy display settings and can be configured during query design., D. Display text nodes, The "Display text nodes" property controls whether text nodes (descriptive labels) are shown alongside the hierarchy nodes in the query output. Text nodes provide additional context or descriptions for each node, making the hierarchy easier to interpret for end users., Reference: This property is commonly used in SAP BW and SAP Data Engineer - Data Fabric to enhance the readability of hierarchical data in reports., Incorrect Options:A. Position of child nodes, The position of child nodes within a hierarchy is determined by the hierarchy's structure and cannot be altered in the query definition. It is a fixed property defined during the creation of the hierarchy in the backend system., Reference: SAP documentation specifies that structural properties like node positions are not modifiable at the query level., E. Time dependency, Time dependency is a characteristic of the hierarchy itself, indicating whether the hierarchy changes over time (e.g., organizational structures that evolve). This property is defined during the creation of the hierarchy and cannot be changed in the query definition., Reference: SAP BW and SAP Data Engineer - Data Fabric treat time-dependent hierarchies as static entities in the query context, meaning their time dependency cannot be altered dynamically., Conclusion:The three correct answers—Sort direction,Exp to level, andDisplay text nodes—are properties that can be modified in the query definition to customize the presentation of external hierarchies. These adjustments provide flexibility in how hierarchical data is displayed and analyzed, enhancing the usability of reports and dashboards in SAP Data Engineer - Data Fabric environments., , ]
