SAP BW / 4 HANA
What is SAP BW / 4 HANA?

SAP BW/4HANA is the next generation of SAP Business Warehouse powered by SAP HANA. BW / 4 HANA is specially designed to run on SAP HANA only. It delivers new levels of simplicity for building and operating data warehouse solutions with flexible data management capabilities in modernized user experience.

This course provides a high-level overview of SAP BW/4HANA. Starting from the value proposition, we cover all the major functional aspects of it. Another central aspect for customers running SAP BW powered by SAP HANA is the migration path to SAP BW/4HANA. Finally, we will have a look at the future development roadmap for SAP BW/4HANA.

Simplicity, Openness, Modern UI, High Performance

Simplicity: The number of data objects will be reduced-Eliminates data redundancies, increases consistency, and results in a smaller footprint Administration efforts to maintain data objects -and error-prone data flows will be reduced BW/4 HANA will leverage HANA's data life cycle features by automatically distributing the data to hot and warm storage areas.

Openness: Customers see great benefit in the possibility to expose BW/ 4 HANA Models and Native HANA Views. These automatically generated HANA views can be consumed in visualization tools like Business Objects Lumira or cloud or they can be used by customers to build their own data models on top of BW /4 HANA data models.

Modern UI: Business Objects cloud (instead of BEX) will provide a modern UX for visualization storytelling and exploration. BW /4 HANA Data can also be accessed by Digital Boardroom. UX will improve for administrators, as modern HANA studios and front ends will be used instead of SAP GUIS front end.

High Performance: Operations and calculations on details level can be pushed down to HANA resulting in a superior performance.

HANA Specific libraries can be utilized running in the HANA platform. As with BW on HANA scale-out will be a de facto standard for customer implementations.
SAP BW/4HANA 2.0 SAP Certified Application Associate
Data Warehousing with SAP BW/4HANA
Unit 1: Introduction to SAP HANA
  1. Describing the Concepts of Business Intelligence (BI) and Data Warehousing
  2. Describing the Evolution and the Data Layout of SAP HANA
  3. Outlining the basics of SAP Business Warehouse with SAP BW/4HANA
Unit 2: Master Data in SAP Business Warehouse BW/4HANA
  1. Describing Characteristic InfoObjects
  2. Creating a generic DataSource
  3. Creating Transformation and Data Transfer Process (DTP) for Attribute Master Data Loading
  4. Outlining the Graphical Data Flow Modeling
  5. Deleting and Activating Master Data
Unit 3: Transactional Data in SAP BW/4HANA
  1. Introducing SAP BW/4HANA InfoProvider
  2. Creating a Key Figure InfoObject
  3. Modeling Data Mart DataStore Objects (advanced)
  4. Creating a Data Flow for Transaction Data
  5. Creating a Standard DataStore Object and Loading Data from a Flatfile DataSource
  6. Modeling CompositeProviders
Unit 4: HANA Native Modeling
  1. Exploring the SAP HANA Modeler Perspective
  2. Outlining Data Provisioning in SAP HANA
  3. Introducing SAP HANA Native Modeling
  4. Combining SAP BW/4HANA InfoProvider with SAP HANA Views
Unit 5: Open ODS Views
  1. Creating Open ODS Views
  2. Creating DataSources from Open ODS View
Unit 6: Advanced SAP BW/4HANA Topics
  1. Explaining Details of Transformation and Data Transfer Process (DTP) in SAP BW/4HANA
  2. Explaining InfoObjects Enhancements for SAP BW/4HANA
  3. Administrating DataStore Objects (advanced)
  4. Introducing Process Chains
  5. Explaining SAP HANA Delta Merge in SAP BW/4HANA
  6. Introducing Business Intelligence (BI) Content
  7. Introducing S/4HANA
SAP BW/4HANA Data Modeling
Unit 1: Challenges for Data Modeling
  1. Introduction to Data Modelling
  2. Solving Requirement Conflicts
Unit 2: Overview of the Business Case
  1. Getting to Know the ItelO Case Study
  2. Understanding the Source System Data Model
Unit 3: Modeling Approaches in SAP BW/4HANA
  1. Introducing SAP HANA Modeling
  2. Advantages and Issues of SAP BW/4HANA Modeling
  3. Comparing SAP BW/4HANA Focus, SAP HANA Focus, and Mixed Strategies
  4. The Future of Data Warehousing
Unit 4: Best Practice Standards in SAP BW/4HANA Modeling
  1. Understanding Object Changeability
  2. Separating Master Data and Transactional Data
  3. Tracking History
  4. Mapping and Transforming Data
  5. Designing an SAP BW/4HANA Layered Scalable Architecture (LSA++)
  6. Understanding Physical and Logical Partitioning
Unit 5: Process of Modeling
  1. Defining the Sequence of SAP BW Projects
  2. Planning the Phases of an SAP BW/4HANA Project
  3. Developing an SAP BW/4HANA Data Model
Unit 6: SAP BW/4HANA Content Add-On
  1. Working with SAP Business Content
  2. Introducing ABAP CDS Views provided by SAP BW/4HANA
Unit 7: Implementing SAP BW/4HANA Field-Based Models
  1. Implementing Field-Based Modeling with Open ODS Views
  2. Understanding Snapshot and Corporate Memory Models
Unit 8: Implementing Models in SAP BW/4HANA
  1. Modeling and Implementing SAP BW/4HANA Master Data
  2. Modeling and Implementing Advanced DataStore Objects (ADSOs)
  3. Modeling and Implementing InfoSources and Transformations
  4. Modeling and Implementing CompositeProviders
Unit 9: Implementing Native SAP HANA Views
  1. Modeling Master Data in SAP HANA Views
  2. Modeling Transactional Data in SAP HANA Views
Unit 10: Implementing Agile Data Marts
  1. Generating External SAP HANA Views for SAP BW/4HANA Objects
  2. Implementing Mixed Scenarios
Unit 11: Implementing SAP BW/4HANA Workspaces
  1. Implementing SAP BW/4HANA Workspaces
Unit 12: Advanced Modeling in SAP BW/4HANA
  1. Introducing the SAP HANA Analysis Process (HAP)
  2. Defining Inventory Scenarios
  3. Stock Coverage
  4. Planning Mode
  5. Additional Sources of Information for SAP BW/4HANA
SAP BW/4HANA - Data Acquisition
Unit 1: SAP BW/4HANA Strategy and Overview
  1. Optional* Describing the new BW/4HANA Features that affect Data Acquisition
  2. Explaining the Strategy for SAP BW/4HANA
  3. Outlining the Course Landscape
  4. Using BW Modeling Tools
Unit 2: Data Acquisition into SAP BW/4HANA with Operational Data Provisioning (ODP_SAP)
  1. Describing Data Acquisition with Operational Data Provisioning (ODP)
  2. Explaining Source Systems
  3. Working with the Application Component Hierarchy
  4. Managing DataSources in SAP ERP Central Component (ECC) and SAP BW
  5. Loading Hierarchies from SAP ECC
  6. Managing the ODP Data Transfer Processes (DTPs)
  7. Describing the role of the Service API and Debugging an SAP ECC DataSource
  8. Analyzing the Operational Delta Queue (ODQ) for ODP -SAP
  9. Debugging Operational Data Provisioning
Unit 3: Operational Data Provisioning Delta Management (ODP_SAP)
  1. Explaining Terms and Basic Processes of Delta Enabled DataSources
  2. Configuring the Logistics Data Extraction (LO Cockpit)
  3. Appending BI Content DataSources
  4. Discussing the New GL Data Extraction
  5. Configuring Generic Delta DataSources
Unit 4: SAP BW/4HANA Data Extraction from SAP S/4HANA (ODP_CDS)
  1. Introducing SAP S/4HANA
  2. Describing SAP S/4HANA Embedded Analytics
  3. Understanding the Positioning of SAP BW/4HANA with SAP S/4HANA
  4. Describing the SAP S/4HANA Architecture
  5. Describing ABAP CDS Views in a BW Context
  6. Understanding Challenges/Opportunities After Updating to SAP S/4HANA from SAP ECC
Unit 5: Other Types of Operational Data Provisioning in SAP BW/4HANA
  1. Acquiring Data in Real Time with ODP - SLT and Realtime Data Acquisition (RDA)
  2. Discussing BW - ODP Data Marts
  3. Extracting from ODP - SAP HANA Information Views
Unit 6: Data Acquisition into SAP HANA
  1. Explaining Data Provisioning into SAP HANA
  2. Explaining Virtual Data Provisioning into SAP HANA with Smart Data Access (SDA)
  3. Explaining Data Provisioning into SAP HANA via Smart Data Integration (SDI)
  4. Replicating Data to SAP HANA via SLT
  5. Explaining Data Provisioning into SAP HANA via Flat Files
Unit 7: Data Acquisition into SAP BW/4HANA with the SAP HANA Source System
  1. Introducing the SAP HANA Source System
  2. Comparing SAP BW Data Acquisition Options
  3. Streaming Data into SAP BW4/HANA with SAP HANA Smart Data Integration
Unit 8: Manage and Optimize Data Flow Components in SAP BW/4HANA
  1. Working with Enhanced Master Data Update
  2. Positioning InfoSources
  3. Debugging DTPs
  4. Working with SAP HANA Optimized Transformations
Unit 9: Big Data Acquisition to SAP BW/4HANA and SAP Data Hub
  1. Introducing the SAP HANA Big Data Source System and SAP HANA Vora
  2. Introducing the SAP Data Hub
Unit 10: Appendix: Not Covered in training class
  1. Optional** Implementing OpenHub Destinations
  2. Optional** Introducing SAP Agile Data Preparation
BW/4HANA Query Design and Analysis
Unit 1: Introduction to SAP HANA and SAP BW/4HANA
  1. Describing the Concepts of Business Intelligence (BI) and Data Warehousing
  2. Describing the Evolution and the Data Layout of SAP HANA
  3. Outlining the basics of SAP Business Warehouse with SAP BW/4HANA
  4. Setting Up SAP BW/4HANA Modeling Tools in SAP HANA Studio
Unit 2: Report Launching and Navigation in Reports
  1. Outlining SAP BusinessObjects BI Platform
  2. Navigating in SAP BusinessObjects Analysis for Microsoft Office
  3. Navigating in SAP Lumira Generic Analysis Document
    4. Unit 3: Simple Queries
    1. Creating Simple Queries
    Unit 4: Key Figures in Queries
    1. Configuring Properties of Key Figures
    2. Creating Restricted Key Figures
    3. Creating Calculated Key Figures
    4. Creating Calculated Key Figures with Boolean Operators
    5. Creating Calculated Key Figures with Exception Aggregation
    Unit 5: Structures in Queries
    1. Creating Structures
    2. Resolving Formula Collision and Working with Cells
    Unit 6: Characteristics, Attributes, and Hierarchies
    1. Configuring the Properties of Characteristics
    2. Creating a Query and Running Display and Navigation Attributes
    3. Adding Hierarchies to Reports
    Unit 7: Variables in Queries
    1. Explaining Variables
    2. Creating Characteristic Value and Text Variables
    3. Applying Business Content Variables
    4. Creating Characteristic Value Variables with a Replacement Path from a Query
    5. Creating Formula Variables
    6. Creating Hierarchy Variables and Hierarchy Node Variables
    Unit 8: Exceptions and Conditions in Queries
    1. Creating a Query and Including Exceptions
    2. Creating a Query and Including Conditions
    Unit 9: Report-Report Interface
    1. Applying the Report-Report Interface
    Unit 10: Query Performance Optimization
    1. Optimizing Query Performance
    2. Describing the SAP BW/4HANA Analytic Manager
    Unit 11: Query Management
    1. Managing Query Objects
    Unit 12: Authorizations Overview
    1. Describing Authorizations
    Unit 13: SAP Analytics Overview
    1. Outlining Strategy and Portfolio: SAP Analytics
    2. SAP Analytics Cloud Overview