Skip to Content

Hello Everyone,

In this document I am going to show you the basic navigation’s we need to do when login to the brand new SAP HANA system.

This includes the following.

1) Adding System

2) Package Creation

1) Adding System: Once the SAP HANA is installed and when we click on ‘HANA Studio’ the below screen will come up.

In the above screen left side, ‘Navigator’ space will show what are all the system available in this Studio. As this is new system the first step we have to do is add the system.

Step1: right click in the Navigator space, click on ‘Add System’

Step2: In the next screen we have to mention ‘Hostname’ and ‘Instance Number’.

Note: We can have multiple systems with same hostname but different instance number.

Select the language and click on ‘Next’.

Step3: Here we have to authenticate this system by providing user name and password.

Click on ‘Next’ and then ‘Finish’ to see you system in the Navigator.

Once the system is added, a schema will be created based with the ‘user name’ we provided for authentication. In this if we drill down the ‘catalog’, we can see the schema with name ‘P1001301’. Schema contains the objects(tables, views) created and customizations done by that particular user.

We have 2 main perspectives in SAP HANA.

i) Administration Console: Where in we can perform all DB level monitoring and activities.

ii) Information Modeler: This is the place where all can create their models in SAP HANA.

2) Package Creation: Package is a collection of objects modeled in SAP HANA. We can create 3 types of models/views in SAP HANA.

i) Attribute View.

ii) Analytic Views

iii) Calculation Views

iv) Analytical Privileges : Authenticate users before data is displayed or authentication of business rules.

Packaged is used to hold this objects in SAP HANA.

Step1: Goto ‘Information Modeler’ perspective (Window –> Open Perspective –>other –>Modeler –>Ok). We will get below screen.

The right side of the above screen is called ‘Quick Launch’ of Information Modeler.All the packages will be grouped under ‘Content’

Step2: We can create the new package in 2 ways

1) Right Click on ‘content’ –> New Package

2) Directly click on ‘Create’ in the Quick Launch.

In then next screen give below details.

Package Name, Description.

Step3: Click on ‘Ok’ to see your package under ‘Content’ folder.

Each Package contains below sub folders.

1) Attribute Views

2) Analytic Views

3) Calculation Views

4) Analytic Privileges.

Hope this document will be helpful for beginers in SAP HANA hands on.

To report this post you need to login first.

18 Comments

You must be Logged on to comment or reply to a post.

      1. Ravindra Channe

        Hi Sreehari,

        The TZHANA training document will cover most of the questions for the HANA certification, but additionally you might need to study the information related to the BO tools. There are questions which are scenario based (modelling scenarios) and related to the BO use cases.

        Please prepare accordingly and you should be able to clear the HANA 1.0 certification.

        Regards,

        Ravi

        (0) 
          1. Lalitha Swaroop Krishna Tangudu

            ya those also will sever your purpose. you can find ECC6 tables like “CE1IDEA” there is an excercise in SAP TechEd like EIM 162 i guess. that would also be fine. And as far as reporting is concerned you just need to know about various drivers,connections and tools available.

            (0) 
    1. Vivek Singh Bhoj

      Hi Gaurav,

      You need to update hosts file in your computer for it

      If you are using Windows then in goto C:\Windows\System32\drivers\etc folder and update the hosts file as

      ip address      HostName

      Eg:

      172.1.1.3      SAPHANA

      (0) 
      1. Gaurav Khandelwal

        hi vivek,

        thanks for reply.

        but i tried to update but editing is not allowed in this file.

        it always shows the msg other program is using this file.

        please help me on that.

        thanks in advance.

        (0) 

Leave a Reply