Home > Courses > Technical > BW HANA
SAP BW HANA TRAINING IN HYDERABAD
Course Duration : 50h
Course Level : Beginner
About the Course
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. SAP Business Warehouse (BW) powered by HANA also known as BW on HANA (BWoH) is SAP’s data modeling, warehousing,
and reporting tool built on the HANA database. SAP BW on HANA (BWoH) runs on the HANA database and therefore it is simpler and faster.
Description
WHAT ARE THE COURSE OBJECTIVES?
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.
BW software supports various databases like Oracle, Microsoft, IBM DB2, Teradata, and many more. BW on HANA suggests that you are using HANA as database for BW data modeling capabilities and no other database is required.
WHAT ARE THE ROLES AND RESPONSIBILITIES AND METHODOLOGY OF THIS MODULE?
- Implementing SAP BW on HANA specific modelling like Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, LSA++, etc.
- Work on HANA Studio – Schemas and tables on HANA, attribute view, analytical view and Calculation views.
- Developing and handling hybrid scenarios – BW data models and HANA views as per the requirement.
- Manage SAP BW tables in HANA distribution environment.
- Experience in integration with BW/BO/HANA is highly required.
- Knowledge on BOBJ tools like WEBI, Lumira, and Design studio is a plus.
WHO SHOULD GO FOR THIS TRAINING
those having advanced level knowledge on SAP BW functions and SAP HANA Native modeling. After completing this course, you will become expertise in maintaining BW on top of HANA database, and exploring some key capabilities on BW powered by HANA.
WHAT ARE THE SKILLS THAT YOU WILL BE LEARNING WITH THIS COURSE?
- Using the new BW/4HANA user interfaces that have been redesigned to support modelling data models and data flows, query building and administration.
- Working with new modelling approaches which lean heavily towards a virtualised data warehouse and mixing SQL based data models from native HANA.
- Using the new best practices for BW/4HANA with LSA++, instead of the old LSA.
- Taking advantage of the staggering data integration possibilities. BW/4HANA can consume any type of data, from anywhere. You need to learn how to connect both physical and virtual data sources.
WHAT ARE THE PREREQUISITES TO LEARN THIS COURSE?
Before you start proceeding with this tutorial, we assume that you are well-versed with basic BW and HANA concepts, like DataStore Objects (DSO), Data Transformations, InfoCubes, Query optimization, HANA Modeling and HANA DB features using HANA Studio. If you are not aware of these concepts, then we recommend that you first go through our tutorials on BW and HANA.
Key Features
Instructor-Led Sessions
50 Hours of Online Live Instructor-Led Classes. Weekend Classes: 24 sessions of 2 hours each. Weekday Classes: 50 sessions of 1 hour each.
Real-Life Case Studies
Live project based on any of the selected use cases, involving implementation of the various concepts.
Assignments
Each class will be followed by practical assignments.
Lifetime Access
You get lifetime access to LMS where presentations, quizzes, installation guide & class recordings.
24 X 7 Expert Support
We have 24×7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.
Certification
After completing your final course project successfully emax will provide you certificate as a SAP Trainee.
Curriculum
INTRODUCTION
- • Evolution of HANA
• Evolution and Architecture of SAP BW with HANA
• Modeling, Extraction and Reporting
• Installation of SAP HANA Studio and SAP GU
2. MODELING of SAP BW 7.5 with SAP HANA:
- The Multi-dimensional Model in SAP BW
- The SAP BW Star Schema Concept
- Extended Star Schema
3. Info Providers:
- Creating data warehousing Objects
- Info Areas
- Info Object Catalogs
- Info Objects-Characteristics
- Info Objects-Key figures
4. INFO PROVIDERS
- Master Data – Attributes, Texts, Hierarchies
• Standard, Write-optimized , Direct Update DSO’s
• Standard Info Cube and Virtual Provider
• Logical Layers: Info Set and Multi Provider
• Open Hub Destination
• Analysis Process designer
5. Process Chains:
• Process Chains and Process Types
• Administration activities
• Real time scenarios from support projects
6. Reporting:
• Business Explorer Query Designer
• Reusable Query Elements
• Filters, Columns & Rows
• Characteristic Restrictions & Free Characteristics
• Formulas & Calculated Key Figures
• Restricted Key figures and Variables with Texts
• Report to Report Interface or Jump Starts
• Exceptions, Conditions, Structures, Cell Definitions
• Filters & Variables
7. ABAP for SAP BI requirements:
• Field level Routine
• Start Routine
• End Routine
• Infopackage level Routine
Course Certification
- Upgrade your skills and stay current with the industry by completing these professional courses, which also provide certification upon completion.
- Certificates are generated after the completion of course.
- Certificates are globally recognized & they upgrade your programming profile.
Reviews
FAQ's
WHAT IF I MISS A CLASS?
- You will never miss a lecture at Emax You can choose either of the option: View the recorded session of the class available in your LMS.
