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.

If Table B is not pruned in a referential join, the possible issues could be:
* C. The Keep flag is activated for the Customer column: This prevents pruning by forcing the inclusion of the column in query execution.
* D. Integrity constraint is set to RIGHT: This setting implies that Table B data must always be considered in the join, disabling pruning.
Pruning depends on join conditions and flags; ensuring no unnecessary constraints is essential for proper optimization.

To create a star schema using a calculation view with measures based on columns from two transaction tables:
* Combine the transaction tables using a join node in a CUBE calculation view:The join node merges the transaction tables into a unified fact table.
* Use a star join node to join the DIMENSIONS to the resulting fact table:The star join node integrates the attributes from the DIMENSION views with the measures in the fact table, completing the star schema design.
This approach adheres to best practices for building efficient star schemas in SAP HANA.(Reference: SAP HANA Star Schema Modeling Guide)

Acalculation view properties filecontains descriptions of all objects defined in the calculation view, such as attributes, measures, joins, and dependencies. This file serves as metadata documentation for understanding the view structure and dependencies.