Skip to Content
Author's profile photo Former Member

Reporting on Hierarchy in SAP-HANA

Overview:


This document explains about how to create Level Hierarchies in SAP-HANA.

Please follow below steps to accomplish this:

1. Create a simple attribute view (ATTRIBUTE_VIEW). This view will join two tables EMP ID_1 and EMP_REGION

  

     /wp-content/uploads/2014/12/1_615143.jpg

2. Select the output fields as shown below (This selection is based on the requirement)

     /wp-content/uploads/2014/12/2_615144.jpg

3. Creation of Hierarchy EMP_ID_1

  1. Click on CREATE hierarchy  as shown below

     /wp-content/uploads/2014/12/3_615145.jpg

     ii. Select the Hierarchy type as – Level Hierarchy

     iii. Provide the input for the Hierarchy levels. Example:-EMP_ID_1 and EMP_REGION

     /wp-content/uploads/2014/12/4_615146.jpg

4. Save and activate. Attribute view is activated

  

     /wp-content/uploads/2014/12/5_615147.jpg

5. Create analytical view by making use of an attribute view created (ATTRIBUTE_VIEW)

  

     /wp-content/uploads/2014/12/6_615152.jpg
  

6. Open MS-Excel and goto DATAàSelect FROM DATA CONNECTION WIZARD

     /wp-content/uploads/2014/12/7_615153.jpg

  

7 . Select OTHER/ADVANCED Option

     /wp-content/uploads/2014/12/8_615154.jpg

  

8. Select SAP-HANA MDX Provider

  

     /wp-content/uploads/2014/12/9_615158.jpg

  

9. Provide SAP-HANA login Credentials

     /wp-content/uploads/2014/12/10_615159.jpg

10. Select the Package and select the Analytical View Created i.e. ANALYTCAL_VIEW

      /wp-content/uploads/2014/12/11_615160.jpg

11. We will get screen like below.

     /wp-content/uploads/2014/12/12_615161.jpg

12. Select Dimensions and Key figures based on the requirement as shown below

     /wp-content/uploads/2014/12/13_615162.jpg

13. Now we are able to view hierarchies

     /wp-content/uploads/2014/12/14_615163.jpg

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo sree hari
      sree hari

      Nicely Presented Dheeru, Expecting More Hana Based Docs..

      Regards

      sreehari Y

      Author's profile photo Former Member
      Former Member

      This is really helpful to beginners to start HANA

      Regards,

      Shiva

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Hari and Shiva,

      Will try to post more and more articles on HANA

      Regards,
      Dheeru

      Author's profile photo Former Member
      Former Member

      This is really helpful for beginners.

      Regards

      Yogee

      Author's profile photo Sampath Kumar
      Sampath Kumar

      yes, really helpful to begininers...

      Author's profile photo Former Member
      Former Member

      Good Article on Hana, nice to know..

      Author's profile photo Former Member
      Former Member

      very useful information 🙂