For any SAP Online Training Email:
[email protected] [email protected] or Visit : www.sritrainings.com
For any SAP Online Training Email:
[email protected] [email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-1
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-2
HA100
@SAP AG
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-3
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
The SAP HANA Studio is delivered in the SAP HANA Appliance and provides an environment for administration , modeling and data provisioning. SAP HANA studio is a Java based application that runs on the Eclipse platform (More information: http://www.eclipse.org). When you start the SAP HANA studio for the first time, you can decide on several perspectives. Perspectives are predefined UI-layouts or views for several application uses. The Modeler Perspective is used by Data Architects to create Reporting Models. The Administration Console is used by SAP HANA administrators to administrate and monitor the engine. The Modeler view is used by BI architects. e
ocumen a on v ew n s o
e curren ava a e ocumen a on.
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-4
HA100
@SAP AG
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
We are starting with the Administration console view. The administration perspective is used to administer and monitor SAP HANA instances. When you start SAP HANA Studio for the first time, there will be no connection to a SAP HANA system maintained yet. It is possible to integrate several systems into one Studio. You can select a cheat sheet view via Window -> Show view -> other Help -> Cheat Sheets creates an additional view on the right side. Using view menu you can choose Adding system and Folders. Now you get the information how to create a new folder or add a new system into the navigator view. To integrate a SAP HANA system into the studio you need to know the server . user/password combination as well to get a connection to the instance. You can import (-> file -> import -> SAP in-memory computing studio -> landscape) a system landscape which has been exported before from another/same studio. Note: to get the imported landscape working you need to insert the passwords for . (Mark the system -> properties -> connection properties)
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-5
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
After the system has been integrated on the left side you will find the navigator view. Here all systems which have been integrated (manual or via import) are listed. We will have a closer look to the tree structure each system has. The physical tables are located in the Navigation Tree under the Default Catalog no e. xpan s no e an one w n a s o sc emas. c emas are use o categorize tables according to customer defined groupings NOTE: During metadata import one defines which schema to hold created tables. ( Currently the replication server loads the meta data into the system schema.) Different schemas can be quite useful for grouping tables into categories that . use when defining Information Models. One model can incorporate tables from multiple schemas. The schemas do not limit your modeling capabilities. The created column views are always located in schema _SYS_BIC, their meta data in schema _SYS_BI. The physical tables are the only storage area for data within SAP HANA. All the n orma on mo e s a w e crea e n e mo e er w resu n a a ase views. Therefore SAP HANA does not persist redundant data for each model and does not create materialized aggregates.
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-6
HA100
@SAP AG
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
There is an integrated system monitor which gives you an administration view about the system landscape. When you use the system overview button all systems which are listed in the navigator tree are listed by default in the system monitor overview. You get the most important information about your systems. Which information is shown can e con gure w con gure v ewer. It is also possible to configure which systems will be shown in system overview. Perhaps you have seen that in the slide here we have several systems twice. By default you get for each Connection (System/User) an entry in the overview. Use system filter to configure the monitor.
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-7
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
The Administration console is pre-delivered by SAP. You can access the administration console by selecting the Administration icon in the top right corner double click on the system in the system monitor double click on the system in the navigator view In the administration console you are administrating HANA instances. starting and stopping the instance backup/recovery of the instance monitor the system configure the engine instance doing the problem analysis
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-8
HA100
@SAP AG
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
When you want to create data models in HANA you have to switch to the modeler perspective in the Studio. With Window -> Open Perspective -> Modeler you can switch to the Quick Launch of the Information Modeler. On the right top edge you find the fast perspective switch. The SAP HANA Studio offers other perspectives e.g. for debugging, resource and team synchronizing.
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-9
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
Above is the modeling section of the SAP HANA Studio. Note: The Quick launch of the modeler is open by default for the first instance in the navigation tree. If you want to change to another system use the left button -> Choose Connection. In the center of the screen you see a quick launch tab that allows the user to quickly jump to various sections of the tool. Create new views (Information Models) and analytic privileges Import and export source schemas, models, data Configure the tool Access documentation of the HANA On the left of the screen you see the navigation tree. Note that there are two main sections in the navigation tree. The Default Catalog node navigates to the physical tables, views, etc. The Information Models node navigates to Attribute Views, Analytic Views, Calculation Views, Analytic Priviliges and Procedures
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-10
HA100
@SAP AG
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
The Modeler node displays the data from a data modeling perspective. Here the user will create: Attribute Views, Analytic Views, , Analytic Privileges and
The physical tables are the only storage area for data within SAP HANA. All the information models that will be created in the modeler result in database views. Therefore SAP HANA does not persist redundant data for each model and does not create materialized aggregates.
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-11
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
Notes: Views are the basic screen elements. A collection of displayed views combined with their placement within the screen builds a perspective. Each view can be moved around via drag & drop.
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-12
HA100
@SAP AG
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
Notes: Reset your perspectives will restore the screen to the default layout…
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com @SAP AG
HA100
2-13
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com
For any SAP Online Training Email:
[email protected] or Visit : www.sritrainings.com 2-14
HA100
@SAP AG