Shared hierarchies in SAP HANA offer the following functionalities:
Provide reusable hierarchies for drilldown in a CUBE with star join:Shared hierarchies can be defined once and reused across multiple calculation views, particularly in CUBE views with star joins. This promotes consistency and efficiency in hierarchical data representation and drilldown capabilities.
SAP Learning
Enable SQL SELECT statements to access hierarchies:Shared hierarchies are accessible via SQL, allowing for direct querying and manipulation using standard SQL commands. This facilitates integration with various applications and reporting tools that utilize SQL for data access.
SAP Learning
Options B and C are not correct:
Access hierarchies created in external schemas:Shared hierarchies are typically managed within the SAP HANA environment and may not directly access hierarchies from external schemas without additional configuration.
Provide reusable hierarchies for drilldown in a CUBE without star join:While shared hierarchies can be used in various calculation views, their primary integration and reuse are optimized for CUBE views with star joins.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit