1.

Define the Hierarchy? What are the kinds of hierarchy supported in HANA?

Answer»

To structure and specify the relationships among attributes in a modelling view. HIERARCHIES are implemented.

Companies describe hierarchies for classification of information, letting roll-up and drill-down analysis. For instance, a sales company might assign a salesperson to a COUNTRY and a country is assigned to a region. Then the sales data can be CALCULATED and scrutinized by region, country, or salesperson.

There are two kinds of hierarchies:

  • Level Hierarchies are rigid hierarchies, where you can access the root and the child nodes in the defined order. For instance, organizational structures.
  • Parent/Child Hierarchies are regarded as value hierarchies, i.e, hierarchies obtained from the value of a node. Such as a BILL of Materials (BOM) includes Assembly and Part hierarchies, and an Employee MASTER record includes Employee and Manager data. The hierarchy can be analyzed on the basis of a selected parent, also, there are scenarios where the child can be a parent.


Discussion

No Comment Found

Related InterviewSolutions