Creating a hierarchy in SAP HANA

SAP HANA provides us with the possibility to create hierarchies on top of several different objects. For example, if we create a hierarchy on an attribute view, we will automatically have access to the hierarchy in any analytic or calculation view we build.

Note

It is important to note here that it is not currently possible to use the Studio to see the results of hierarchy development. Hierarchies can only be visualized outside the Studio, in reporting software. Additionally, only reporting software which uses the MDX language to "talk" to SAP HANA can see and therefore use hierarchies. This means that reporting applications built upon SAP's BusinessObjects suite cannot currently (as of SPS5, revision 45 of SAP HANA) use hierarchies you build. If however you deploy your reporting application in Microsoft Excel or some other tool which uses MDX, you will be able to use your hierarchy. We will be looking in detail at the possibilities offered by different reporting...