Basic Navigations in SAP HANA Brand New System
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.
Good Doc Venkat!!!
Waiting for the further steps of this document... 🙂
Good document for HANA learner, looking for further documents on HANA
Neat and clear...Thanks for sharing venkat.
I have question about the HANA certification, Is TZHANA document good enough to certify with some exposure of the practice?Please advise me.
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.
do you have modelling related BO cases? if yes can i have those?Thanks.
Yes regarding certification Just follow TZHANA and practice the excercises which is available in SAP TechEd. It is enough.
The practice exercise are e-fashion and Sflight?
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.
Nice one ...Thanks !!! for the beginers this document is very useful
Now if you want to go for certification, BW on HANA is also compulsory.
Please check with SAP once.
You can have a look at my two other documents on SAP HANA.
Basic Navigation is really helpful, thanks for sharing. Good 😎
i installed hana studio and client.
but i getting error "Host name is known".
please help me on that.
thnaks in advance??
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
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.
When you enter hostname in your hana studio instead of entering hostname like SAPHANA, enter ip address and try again
thanks for reply.
i found the problem ..i need to open this text file as
administrative mode now its working fine.