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)

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

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

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

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

1. Graphical &
2. 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

  

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

 

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

 

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

 

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

 

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