Activities In SAP HANA STUDIO
Activities
(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
6) PROCEDURES
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)
Referents
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)
Preference
2) Modular
Content models ------ (To export models (views) from client system)
Content models (server) – (To export models from server)
3) Run / Debug
Breakpoints
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)
6) MIGRATE
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
NOTE: -
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)
Debug
Graphic
Life cycle management
RCP Perspective
Resource
Excel
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.
IMDB ODBC 1.0
IMDB ODBC 1.0
IMDB JDBC 1.0
IMDB SQLDBC 1.0
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
OK
In next dialogue box ------- select ------- package
Note:
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)
Finish,
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
| OK |
OLAP Drill Through
Maximum number of records to retrieve
Definition (Tab)
Connection string ------- will get connection ------- format ------
Ok
Provide user name and password
So will get pivot option in website
Drag Required fields
Example
(Filter) Shop Facts ---------- All object
1
2
3
4
………etc
For an Indepth knowledge on SAP HANA, click on below