Activities
NEW:- To create different components
Package
To create packages by providing NAME, Description, Delivery unit, Language, End-user Responsibilities
Attribute View: To create Attribute views By providing name description & package
Here we can create
Standard view (user-defined)
Time-based (To maintain time-related data)
Desired & (it takes to copy from already existed view & we can’t change the structure)
Copy From (Here we can take a copy from already existed view & wean change the structures)
Analytic view: To create Analytic view By providing Name, Description (And Provide tables, Attributes views based on requirement)
Calculated views: To create a 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 a script, output structure & input structures)
Analytic privileges: To create privileges on all views by Name, description of analytic privileges
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: Definers Rights (Definer only can execute this procedure)
Invokers Rights (To excite this procedure by end-user)
Access modes: Read-only (After defining procedure only we can read)
Read, write (After defining procedure we can edit write modes)
If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administration Training" This course will help you to achieve excellence in this domain.
Content: To manage Tables & Views
Validate: here we can validate n number of views
(By selecting multiple packages)
Activate: Here we can activate and number of views
(By selecting multiple packages)
Man Copy: To Copy and number of models from the source System to HANA
Import: To Import different component form an external system
Here we can Import
Generate: Archive files ------ (To import zip files)
Existing projects into works place -----------(To import a project from de relevant ------- testing -------- production)
File system -------- (importing file system)
Referents
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)
Run / Debug: Breakpoints, Launch configuration
Hana studio: Team project set
(to import project team set from client set)
Export
General: Archive files -------- ( To export all models/components in the form of achieving files)
File system ----- (Exporting file system)
Preference
Modular: Content models ------ (To export models (views) from client system)
Content models (server) – (To export models from server)
Run / Debug: Breakpoints, Launch configuration
SAP HANA Studio: Landscape ------ (To export entire landscape from client system)
Tables ----- (To export tables form HANA DATABASE) (HANA installed drivers / user / sap / HAN / HDXX / work)
Team: Team project set ---------- (To export project team from client set)
MIGRATE: To migrate all type of views from orders to the newest version
Auto Documentation: To Prepare detailed documents about information models
Switch ownership: To Map (Change) contents from one user to another user
C: Set up:- Studio level settings
manage preferences: to set options for General help and install slash update life cycle management, Run / Debug & then Team
Configure import server: To select a Repository of data services per data provisioning purpose. By providing data services server name, repository of data services, ODBC connecting of HANA
Delivery Units: These units mainly used for transport packages from one server Development ------ > Testing ------ >production
Schema Mapping: To providing authorization for selection schemas
Data:- To configure & provisioning options
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)
Data Provisioning: to get data into the HANA DATABASE from the source system by using trigger-based Replication
SQL EDITOR: - To execute SQL commands file HANA STUDIO
Help: Documentation: To get help about HANA STUDIO from WEB
NOTE: Above mentioned activates a specific to systems so we can add system. By providing the 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)
Checkout Our SAP Hana Tutorials
Configuring end-user clients
MS- Excel as an end-user for SAP HANA and the SAP Business objects BI clients can access SAP HANA by means of the SAP IN memory Database (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
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 provides
Host ………………………….
Insure number …………….
Password ……………………
Language (optional)………….
Test connection
OK
In next dialogue box ------- select ------- package
Note:
Will get only analytical & calculated views
In the next window will get the file name (here we can Change file name & click on “Authentication Settings” --------- to provide authentication settings)
Finish,
So, will get the Deluge box about import data
So System will provide three types of formats
1) Table (hidden) we can’t import data in The form of a table)
2) Pivot Table Report
3) Pivot chat and pivot table Report
4) only create a connection
Click on properties
In usage (tab)
Refresh every ----------- (mins)
NOTE: Data will Refresh for every specified minute
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 a pivot option in the website
Drag Required fields
Example
(Filter) Shop Facts ---------- All object
1
2
3
4
………etc
For in-depth knowledge on SAP HANA, click on below
- Performance Tuning in SAP HANA
- Security in SAP HANA
- Organizing system Landscapes in SAP Hana
- Analytical Privileges in SAP HANA
- Security in SAP HANA
- SAP HANA Views