Course Description: SP BW 7.5 on HANA Advanced Course
-
Individualized support in Spanish
-
Access duration: 3 months
-
Duration in hours: approximately 170 hours, for an average participant with a certain level of basic knowledge of technical English language and technology
- Fee: Request offer
-
Laboratories, practices and activities: As indicated in the attached video
Introduction
SAP BW is a data warehouse tool. In simple terms, it integrates data from different sources, transforms and consolidates, cleanses and stores data as well. It also includes data modeling, administration, and staging. Content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance as it is pre-configured with intelligence about a company's business process, providing faster return on information. SAP BW remains open to different source code system, and also has ease of implementation and maintenance. Enterprise demand for end users who need expertise in integrating ERP data into corporate data warehouses is growing exponentially. This creates great opportunities for certified SAP BW professionals in defining their professional career.
Course objectives
After completion of this course, the participant:
- Understand the latest developments, capabilities and concepts of SAP BW 7.5 on HANA
- Get an overview of how to migrate and use SAP BW with SAP HANA
- Obtain the knowledge to migrate standard objects in SAP BW to InfoProviders 4 optimized for HANA.
- Gain the ability to understand real-time data integration and agile data modeling
- Gain knowledge about data provisioning methods related to SAP HANA for SAP BW 7.5
- Learn about BW Enterprise Data Warehousing and its application
- Understand HANA modeling and its use in your application
Course content
Unit 1: Introduction to SAP HANA Studio
Introduction to SAP HANA
Preview
History of SAP HANA
Overview of SAP HANA Studio
SAP HANA Technology Innovations
Unit 2: SAP HANA Architecture
SAP HANA Architecture
Preview
Index Server
Persistence Layer
Unit 3: Data Provision Methods
Overview of Data Provision Methods
Preview
Flat file Uploading
How to get multidimensional Sales Report
Overview of Business Objects Data Services using ETL-based approach
Unit 4: Accounts Payable
Introduction to SAP HANA Information Models
Preview
Analytical View for COPA Plan using Attribute views and COPA Actual
How to use join operators in building Calculation view
Methods to create Calculation view
Unit 5: Overview of SAP BW 7.5 on HANA 1.0
Overview of SAP BW 7.5 on HANA 1.0
Data Warehousing Workbench
Unit 6: InfoObjects and DataStore Objects
Overview of InfoObjects
Creating Characteristics under Catalog
InfoObjects Characteristics and Key Figures
Classification of Master Data
Creating Characteristics
Overview of Key Figures and Data Flow
Overview of DataStore Objects
How to load transactional data to DataStore Objects
SAP HANA Optimized DSO
Lookups on Active data DSO
Unit 7: SAP HANA InfoSource and Transformations
Explaining Transformations Framework and Expert Routines using Scenario based example
Mapping One Source Field to Target Field
Working with Expert Routines
Writing Expert Routines Code in ABAP
Introduction to InfoSource and Execution of two transformations before executing multiple transformations
InfoSource as a uniform source for several targets as targets from different sources
Return Tables using Transformation
Creating Dataflow using GUI Data flow in SAP BW on HANA and BW Oracle
Unit 8: InfoCube
DTP and its role in loading data to InfoCube in Extraction mode
Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes
Unit 9: SLT Configuration, MultiProviders and Extractions
Steps for performing SLT Configuration
Explaining the three scenarios to implement in SLT
Introduction to MultiProvider and Creating MultiProvider in SAP BW 7.5
How are MultiProviders and InfoSets similar?
Mixed Models
ECC Extractions
Different Extractor types
Steps for Data Extraction method from Non-SAP Source systems
ECC Extractor using Business Content Extractors for Accounts Receivable
Loading data for characteristics, Master data using Business Content Extractors
Unit 10: BW Reporting
Introduction to BW Reporting - BEx Reporting Suit
Important Business Explorer Designers
BEx Query Navigation Options in WebQuery
Creating KeyFigure at InfoProvider and query level
Previous requirements
-
Proficient in basic data storage concepts.
- It is advisable to have experience in the ABAP language
This course is best suited for the following professionals:
- SAP BW Practitioners
2. SAP BW Application Consultants
3. SAP Technical and Functional Consultants
4. Professionals with interest in Data Warehousing
5. Software Analysts and Mainframe Professionals
6. Project Managers and Business Objects Professionals
7. Those who aspire to a career in SAP BI/B
Language
Contents: An important part of the course is in the English language as well as the practices and laboratories.
Fee
If you are interested in taking this course in any training modality, please contact us.
