SAP HANA Landscape with Business Objects
Settings at HANA system level
HANA DB creation secure uid & pword.
Creation of HANA ODBC connection
Settings at BO Environment
ROLAP connection at BO Information Design tool layer
1----------- Data Replication
2.0-------- Persistence Layer
2.1-------- HANA DB (In Memory DST)
3.0-------- View (View Schusses)
3.1-------- HANA Metadata mgmt.
4.0 -------- DDBC / TDT for BO HANA DB
5 ---------- Semantic Layer
6 ----------- Project (Domain Specification)
7 ---------- Relational conn (1-N) system/view
8 ---------- Combining one/more ROUAP Conn in BO schema.
9 --------- Business intelligence Layer
10 ------- Business intelligence
DS in SAP HANA Landscape
Need :- To do ETL based data replication
Desired to gain proficiency on SAP HANA? Explore the blog post on SAP HANA Training to become a pro in SAP HANA.
Settings at BW
If your BW system is less than 7.3 version then add DS as source system manually
Note: For BI / BW system (7.3) version DS is already added as Source System.
Settings at DS Level
In DS Mgmt console, create connection using RFC details DS/R3 (or) BW system
In DS Designer Create,
- SAP Application Data store
- SAP BW Source DST (data store)
SAP Target (Data store)
- NON SAP ERP / DB Data store
- HANA DST
Settings at BO CMC
In BO CMC in application (tab) select DS and encrypted file message which is given at HANA studio
Create Replication jobs (using LCM (ube cycle manager ) for periodical replication)
Settings at HANA Studio
Add Data Services system encrypted file message
Enable replication at DS System level
Note : We generates prefer extractors metadata to replicate from source to target
Configure the HANA Hardware whiles is provided by IBM, HP, CISCO
Select storage layer either data vol or log volumes
Based on storage layer select persistence layer either page mgrnt, logger mgrnt
Relational engine select row store, column store or object store based on our requirement
Check out the top SAP HANA Interview Questions now!
We can retrieve data about COPA module seem ECC6 through ETL tool (Data Services)
- We can retrieve data related to COPA in ECC 6 using log based (Sybose)
We can retrieve data from NONSAP cubes using ETL (Data Services)
ERP Replication method in Three System Landscape
Trigger Based Replication
ETL Based Replication
Loading Data Into SAP HANA
If replication process is ETL based & Trigger based then data is mapped into mappage management
If it is log base replication then data is mapped into database via logger under supervision of transaction Manager
In HANA Landscape implementation, we do technical modeling (DST) and views at HANA studio.
We also do business modeling using BO information deign tool (Data foundation and Business layers) with respective to reports & dashboard.
Metadata Manager stores all the views and DST.
We can create crystal reports, dashboard (XCelsius), Advanced Analysis, Explorer, Webi.
If further any modification for report we can do changes in IDT
For an Indepth knowledge on SAP HANA, click on below