Provisioning & replication in SAP Hana

Provisioning & replication:-

It is nothing to bring data from different sources like SAP & NON SAP system. There are three Replication types in HANA

Log based

LT (trigger based)

Main purpose of above replication type to bring data from different source system to the tables under catalog:

We can also bring data from data store in data services – by using provisioning as well as we can bring tables form different system by using provisioning (LT Replication).

MODELLING:-

(A) Modeling at HANA STUDIO (administrator) developer):-

Schema is to organize columns views, tables a vies, & procedures.

Every objects comes under ‘schema’ only

For HANA modeling we need to follow Data ware house concepts like MDX, ER-Model.

Creating views:

(a) for creating view right click on table àselect new view, in data foundation pane add multiple tables based on our Requirement

(b) Join multiple tables by using inner, outer (Lift, Right & full) Joins.

Creating column views:-

There are three types of views:

1) attribute

2) analytic Views

3) calculated

1) Attribute view:-

Right click on attribute, create new attributes, select required tables

& Join them data foundation

Drag required field from tables and make at least one attribute as key attribute

Create customized attribute based on our requirement as well as (level based & parent child)

2) Analytic view:-

Right click on packages - - > Create new analytic

& select required table (at least one fact table)

& select Required attribute views

If we take multiple tables Joins them in data foundation pane

Select required fields from table as attributes and measures.

Create custom calculated attributes, calculated measures & the variables restricted measures.

In Logic – view pane connect our data foundation table to selected attributed view tables

& activate

3) Calculated views:-

Right click on package - - > create new calculate view

Sele cam create two types of calculated views based on DRU requirements

Graphical &

Script

1.Graphical:-

Select required tables

Select attribute, calculate & analytical views based on our requirement.

Connect tables views, by using union, projection, Join (inner, outer, Left, Right, full) joins

And connect them to output structure clarity objects as attributes, measurer

Create custom measures like calculated measures & variables

Scripts:-

Provide code for selecting fields from tables by SQL statements in script pane

& create output parameters as well as variables

In out put component classify objects as measures and the create custom variables and

Activate

Creating Analytical Privileges:-

The main purpose is to create user, roll access permissions on information models (views)

Select views

Select objects in selected views

Select data in selected views

Provide to uses &

Activate

Creating procedures :-

By default system coil cuate produce for each script for calculated vies

even we can create customized procedure

for procedure we need to procedure script

(b) modeling at information composer:-

information composer is a tool for created at client level

The main actions in Information composer on
i) uploading excel files into HANA DB
ii) creating information model (calculated view)

NOTE:-

whenever we upload excel file into HANA system will create a table

That table will appears under ‘IC – tables” catalog

NOTE:-

Whenever we create models at information composer those views appears under

“ _ sys – BIC” catalog

uploading data into database

We need to upload excel ( .xls, .xlsx .csv) files.

After uploading we need to perform cleansingEG:- Merging USA United states of America. As a single file.

Classily measures & attributes ( the column which contains number as data type)

Modeling (creating information models)

Select source A (Table Uploaded file), analytic, attribute, calculated)

Select source B (Table Uploaded file), analytic, attribute, calculated)

Connect source A & B, By using union, join (inner, Left outer Join, Right / full out Join)

Create custom Colum ( attributes / measures)

And manage custom – columns & activate

5.SECURITY:-

He can give access levels, roles & users by providing

SQL privileges

Analytic Privileges

System Privileges

Package privilege

NOTE:-

Whenever we provide analytic privileges to uses, that user can access, for specified data in specified views.

NOTE:-

Users in HANA & users in Business objects in same

6 END USERS ACTIVATIES:-

We can have two types of end users

1) Excel client

2) Business objects enterprise

1) Excel Client :-

We can generate Reports in the from of excel file to bring the data from tables & views

NOTE:

We can bring data from only analytic & calculate vies.

We can bring data form views by using connection called “form connection wizard”

(Import data for unlisted format by using the data connection wizard and OLEDB)

We can bring data from tables by using connection “MICROSOFT QUERY” (import data for an unlisted format by using the Microsoft query wizard and ODBC

2) Business object enterprise:-

We can connect business object enterprise by using HANA DB ODBC connection to the semantic layers

We have two of semantic layers:-

1) IDT (Information Design tool)

2) UDT (universe Design Tool)

For UDT, create connection b/w universe & HANADB, ODBC connection

Create universe bared on reports

For IDF, create connection b/w ODBC & TDT public connection into repository
create data foundation & select tables / view from schemas, design structures, based on reports create business layers and select our foundation activate publish business layer and we can publish into system repository

We can create four types of reports

Analysis

Explorer

webI

Dashboards