Activities In SAP HANA STUDIO

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 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)

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, 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

Excel

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

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 select from Data connection wizard Will get Dialogue box about data connection wizard Select “other/advanced” Next

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

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

Insure number …………….

Password ……………………

Language (optional)………….

Test connection

OK

In the 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 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