NEW:- To create different components
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 existing view & we can’t change the structure)
Copy From (Here we can take a copy from the already existing view & wean change the structures)
Analytic view: To create an 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, analytically 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, and 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 the procedure only we can read)
Read, write (After defining the 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)
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, a repository of data services, ODBC connecting of HANA
Delivery Units: These units are mainly used for transport packages from one server Development ------ > Testing ------ >production
Schema Mapping: To provide authorization for the selection of 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 date & 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 activities a specific to systems so we can add systems. 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
Here we can create two types of connections
1) from the 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 Blog on SAP HANA Tutorial |
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 select from Data connection wizard Will get Dialogue box about data connection wizard Select “other/advanced” Next
Host ………………………….
Insure number …………….
Password ……………………
Language (optional)………….
Test connection
OK
In the next dialogue box ------- select ------- package
Will get only analytical & calculated views
In the next window will get the file name (here we can Change the file name & click on “Authentication Settings” --------- to provide authentication settings)
Finish,
So, will get the Deluge box about importing 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 colour
Font style
Text colour
OK |
OLAP Drill Through the Maximum number of records to retrieve
Definition (Tab)
Connection string ------- will get connection ------- format ------
Ok
Provide username and password
So will get a pivot option on the website
Drag Required fields
Example
(Filter) Shop Facts ---------- All object
1
2
3
4
………etc
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox