(A) NEW:- To create different components

1) Package

To create packages by provide NAME, Description, Delivery unit, Language, End user Responsibilities

2) Attribute View

To create Attribute views By providing name description & package

Here we can create

(1) Standard view                          (user defined)

(2) Time based                                (To maintain time related data)

(3) Desired &                                    (it takes copy from already existed view & we can’t change    change the structure)

(4) Copy From                                 (Here we can take copy from already existed view & wean change the structures)

3) Analytic view

 To create Analytic view By provide Name, Description (And Provide tables, Attributes views based on requirement)

4) Calculated views

To create calculated view by providing Name, description, & package & type

Here we can create two types of calculated views

1) GRAPHICAL & By using tables, views (Attribute, analytic calculated views)

2) SCRIPT (By using script, output structure & input structures)

5) Analytic privileges

To create privileges on all views by Name, description of analytic privileges


To create procedures for calculated views  by Name, Description, Schema, package run with Access mode.

Schema:- Here we can select our required schema

Run with:- 1) Definers Rights (Definer only can executes this procedure)

2) Invokers Rights (To excite these procedure by end-user)

Desired to gain proficiency on SAP HANA? Explore the blog post on SAP HANA Training to become a pro in SAP HANA.

Access modes:-

1) Read only (After defining procedure only we can read)

2) Read, write (After defining procedure we can edit write modes)

(B) Content: To manage Tables & Views

1) Validate:  here we can validate n number of views

(By selecting multiple packages)

2) Activate:  Here we can activate and number of views

(By selecting multiple packages)

3) Man Copy: To Copy and number of models from source  System to HANA

4) Import:  To Import different component form external system

Here we can Import

1) Generate

Archive files ------ (To import zip files)

Existing projects into works place -----------(To import project from de relevant ------- testing -------- production)

File system -------- (importing file system)


2) Modular

Content models --- (To import models (views) from client system)

Content models (server) ----- (To import models from server)

Mass import source objects --- (to import entire all objects with tables)

Source objects ----- (To import models)

3) Run / Debug

Break points

Launch configuration

4) Hana studio

Team project set

(to import project team set from client set)

5) Export

1) General

Archive files -------- ( To export all models / components in the form of achieve files

File system ----- (Exporting file system)


2) Modular

Content models ------ (To export models (views) from client system)

Content models (server) – (To export models from server)

3) Run / Debug


Launch configuration

4) SAP HANA Studio

Landscape ------ (To export entire landscape from client system)

Tables ----- (To export tables form HANA DATA BASE) (HANA installed drivers / user / sap / HAN / HDXX / work)

5) Team

Team project set ---------- (To export project team from client set)


To migrate all type of views from orders to newest version

7) Auto Documentation

To Prepare detailed documents about information models

8) Switch ownership

To Map (Change) contents from one user to other user

9) C: Set up:- Studio level settings

a) manage preferences :- to set options for General help and install slash update life cycle management, Run / Debug & then Team

10) Configure import server

To select Repository of data services per data provisioning purpose. By providing data services server name, repository of data services, ODBC connecting of HANA

11) Delivery Units

These units mainly used for transport packages from one server Development ------ > Testing ------ >production

12) Schema Mapping

To providing authorization for selection schemas

(D) Data:- To configure & provisioning options

(a) To tenacity Time data (To Create Time based data on selected years)

Time based data is (year, Quarter, month, week, day, hour, minute, ex condition data & time)

(b) Data Provisioning: to get data into the HANA DATA BASE from source system by using  trigger  based Replication

(C) SQL EDITOR: - To execute SQL commands file HANA STUDIO

(E) Help: (a) Documentation: To get help about HANA STUDIO from WEB


Above mentioned activates an specific to systems so we can add system. By providing Host server, instance number, user ID & password.

NOTE: - We have different notes in HANA STUDIO

Administration console (default)



Life cycle management

RCP Perspective




Here we can create two types of connections

1) from data connection wizard:  (import data for an unlisted from format by using the Data Connection wizard and OLE DB)

2) From MICROSFT QUERY:- (import data from an unlisted format by using the Microsoft Query Wizard and ODBC)

Configuring end user clients

MS- Excel as end user for SAP HANA and the SAP Business objects BI clients can access SAP HANA by means of the SAP IN memory Data base (IMDB) client. The

IMDB client 1.0 comprises the following interfaces / driers.





1) Connecting views to excel  (From data connection wizard

Open excl ------ Go to data tab

Select from other sources and again selects from Data connection wizard

Will get Dialogue box about date connection wizard

Select “other /  advanced”Next

  • In provider (tab) select “SAP HANA MDX Provider”
  • Next
  • Connection tab provide

Host ………………………….

Insure number …………….

Password ……………………

Language (optional)………….

Test connection


In next dialogue box ------- select ------- package


Will get only analytical & calculated views

In next window will get file name (here we can Change file name & click on “Authentication Settings” --------- to provide authentication settings)


So, will get Deluge box about import data

So System will provide three types of formats

1) Table (hided) we can’t import data in The form of table)

2) Pivot Table Report

3) Pivot chat and pivot table Report

4) only create connection

Click on properties

In usage (tab)

Refresh every ----------- (mins)

NOTE :- Data will Refresh for every specified minutes

Refresh data when opening the file

OLAP Server format

Number format

Fill color

Font style

Text color


OLAP Drill Through

Maximum number of records to retrieve

Definition (Tab)

Connection string ------- will get connection ------- format ------


Provide user name and password

So will get pivot option in website

Drag Required fields




(Filter) Shop Facts ---------- All object







For an Indepth knowledge on SAP HANA, click on below