Creating hierarchies
Hierarchies are created to maintain data in a structured format, such as maintaining customer or employee data based on their roles and splitting data based on geographies. Hierarchical data is very useful for organizational purposes during decision making.
How to do it…
Two types of hierarchies can be created in SAP HANA: the level hierarchy and parent-child hierarchy in the attribute view or analytic view. The hierarchies are initially created in the attribute view and later can be combined in the analytic view or calculation view for consumption in report as per business requirements. Let us create both types of hierarchies in attribute views. When these attribute views are used in analytic views, the hierarchies created ...
Get SAP HANA Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
