Provisioning & Replication in SAP HANA

Ratings:
(4.3)
Views:2497
Banner-Img
  • Share this blog:

Provisioning & replication 

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

  1. Log-based
  2. ETL
  3. LT (trigger-based)

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

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

MODELLING

Modelling at HANA STUDIO (administrator) developer)

  • The schema is to organize columns views, tables vies, & procedures.
  • Every object comes under ‘schema’ only
  • For HANA modeling we need to follow Data warehouse concepts like MDX, and ER-Model.

1. Creating views

  1. for creating a view right-click on the table and select new view, in the data foundation pane add multiple tables based on our Requirement
  2. Join multiple tables by using inner, and outer (Lift, Right & full) Joins. (c) Select Require column in the column pane & activate  

2. Creating column views

There are three types of views:

1) attribute

2) analytic Views

3) calculated  

1) Attribute view

  • Right-click on the attribute, create new attributes, select required tables
  • & Join them data foundation
  • Drag required field from tables and make at least one attribute as a key attribute
  • Create a customized attribute based on our requirement as well as (level based & parent-child)

 2) Analytic view

  • Right-click on packages - - > Create new analytic
  • & select the required table (at least one fact table)
  • & select Required attribute views
  • If we take multiple tables Joins them in the data foundation pane
  • Select the required fields from the 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
  1. Graphical &
  2. Script

 1. Graphical

  • Select the 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

  2. Scripts

  • Provide code for selecting fields from tables by SQL statements in the script pane
  • & create output parameters as well as variables
  • In the output, components classify objects as measures and create custom variables and
  • Activate

 4. Creating Analytical Privileges

  • The main purpose is to create a user and roll access permissions on information models (views)
  • Select views
  • Select objects in selected views
  • Select data in selected views
  • Provide to users &
  • Activate

5. Creating procedures

  • By default system coil curates produce for each script for calculated vies
  • even we can create a customized procedure
  • for a procedure, we need to procedure script

 Modeling at information composer

  • an information composer is a tool for creating at the client level
  • The main actions in Information composer on i) uploading excel files into HANA DB ii) creating an information model (calculated view)

  NOTE:- whenever we upload an excel file into the HANA system will create a table That table will appear under ‘IC – tables” catalog  

NOTE:- Whenever we create models at information composer those views appears under “ _ sys – BIC” catalog  

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.

 

Uploading data into the database

  • We need to upload Excel ( .xls, .xlsx .csv) files.
  • After uploading we need to perform cleansing:- Merging USA United States of America. As a single file.
  • Classily measures & attributes ( the column which contains number as data type)

Modelling (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

SECURITY

He can give access levels, roles & users by providing

  1. SQL privileges
  2. Analytic Privileges
  3. System Privileges
  4. 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 the same  

END USERS ACTIVITIES

We can have two types of end-users

1) Excel client

2) Business objects enterprise  

Excel Client

We can generate reports in the form 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 a 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

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 the system repository
  • We can create four types of reports
  • Analysis
  • Explorer
  • web
  • Dashboards

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

About Author
Authorlogo
Name
TekSlate
Author Bio

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.