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

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

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

1.Creating views:

(a) for creating view right-click on the table select new view, in the data foundation pane add multiple tables based on our Requirement (b) Join multiple tables by using inner, outer (Lift, Right & full) Joins. (c) Select Require column in 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, component classify objects as measures and create custom variables and
  • Activate

 4.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

Checkout Our  Frequently asked SAP Hana Interview Questions

5.Creating procedures:-

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

 (b) 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 Administarion Training"   This course will help you to achieve excellence in this domain.

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

2.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

  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  

6) END USERS ACTIVITIES:-

We can have two types of end-users

1) Excel client

2) Business objects enterprise  

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

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