What is SAP BW on HANA Certification? SAP BW on HANA certification consist of 80 multiple choice questions which you need to complete is 180 minutes of time. SAP has released exams EHANABW12 and EHANABW151 based on latest version of SAP HANA. Passing score of SAP BW on HANA certification is 60% and 58% for respective exam code.
- 1 Unit 1: Introduction to SAP HANA 1 Lesson: Describing the Evolution and the Data Layout of SAP HANA 1 Lesson: Describing the Concepts of Business Intelligence (BI) and Data Warehousing on Any Database 1 Lesson: Outlining the basics of SAP Business Warehouse with SAP BW/4HANA 3 Unit 2: Master Data in SAP Business Warehouse BW/4HANA.
- SAP BW on HANA About the Tutorial SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database. This functionality explores all the key features of HANA database technologies and uses BW as a modeling tool for data modeling and analytical reporting.
What is SAP BW on HANA Architecture?
When SAP BW is driven by HANA, all the tasks are done using HANA database optimized techniques. SAP HANA is accountable to perform key tasks related to Data Warehousing delivering excellent performance while performing analytical reporting.
In the following figure, you can see BW on HANA architecture where all the key activities of BW are HANA optimized −
- HANA-Optimized Data Modeling: InfoCubes
- HANA-Optimized Data Modeling: Advanced DataStore Objects
- HANA-Optimized Data Modeling: Composite Providers
- HANA-Optimized Data Staging
- HANA-Optimized Analytic Manager
- HANA-Optimized Analysis Processes
Layered Scalable Architecture (LSA and LSA++)
In SAP BW, LSA makes it more robust, flexible, and scalable solution to perform enterprise data warehousing functions. LSA is the corporate framework for BW to reliably manage the entire data and metadata life cycle −
- Data delivery
- Data modeling
- Data staging
- Authorizations
- Solution delivery
When BW is implemented on SAP HANA, you can create a different LSA which is more dependent on virtual objects. This is known as LSA++ and it consists of three key layers –
Open Operation Data Store Layer
Sap Bw On Hana Tutorial
This layer is related to the data acquisition layer in SAP BW. The open ODS layer is used to incorporate data into the Data Warehouse and provides the same functionality as the classic data acquisition layer, but with more flexible data integration possibilities.
Core Data Warehouse Layer
This layer is answerable to perform functions like data transformation, data cleansing and consolidation.
Sap Bw Powered By Hana Pdf
Virtual Data Mart Layer
This layer is answerable to combine the data from other layers and to make it obtainable for reporting purposes. This layer comprises all the InfoProviders that combine data using join or union, without saving the result: MultiProvider, Composite Provider, etc. You can use this to access data directly in the SAP HANA database, to allow queries on Composite Provider, Open ODS View.
Sap Bw/4hana And Bw On Hana Pdf Download
Composite provider allows you to merge the data from BW InfoProviders with HANA Modeling views. Union and Joins are performed in SAP HANA and queries can be run on composite providers, like BW InfoProviders.