SAP BW (Business Warehouse)

SAP Business Warehouse (BW) is a model-driven data warehousing product based on the SAP NetWeaver ABAP platform.

SAP BW (Business Warehouse)

SAP Business Warehouse (BW) is a model-driven data warehousing product based on the SAP NetWeaver ABAP platform. It collects, transforms and stores data generated in SAP and non-SAP applications and make it accessible through built-in reporting, business intelligence and analytics tools, as well as third-party software.

SAP BW is also a development platform that programmers use to create and modify data warehouses, perform data management tasks, generate reports and develop analytics applications. Business users typically access SAP BW through an application built by a developer, such as an executive dashboard or mobile app.

SAP BW/4HANABW410
Data Warehousing

The course introduces the BW/4HANA Data Warehousing. Info Providers like Advanced DSO, Open ODS View and Composite Provider are explained and created. Data Extraction and Provisioning is executed with Operational Data Provisioning Framework (ODP). Native HANA data models are created and combined with BW data models.

  • Goals
  • Audience
  • Prerequisites
  • Course based on software release
  • Content
  • Notes
  • REGISTRATION

This course will prepare you to:

  • Understand the architecture and fundamentals of SAP BW/4HANA
  • Create and maintain Info Objects, Advanced Data Store Objects, Composite Providers, and ODS Views
  • Perform master and transaction data load into SAP BW/4HANA
  • Understand SAP HANA native models
Classroom, Virtual Live Classroom
5 days
Details, Configuration & Transaction
English
SAP BW/4HANA
SAP BW/4HANA 1.0 SP05
  • Application Consultant
  • Data Consultant/Manager
  • Database Administrator
  • Developer
  • Enterprise Architect
  • Solution Architect
  • System Architect
  • Technology Consultant

Essential

  • None

Recommended

  • None
  • SAP BW/4HANA 1.0 SP05
  • Introduction to SAP BW/4HANA Architecture
  • SAP Business Warehouse (BW)
  • SAP HANA Studio
  • Info Objects like Characteristics and Key Figures
  • Master Data Loading from SAP source system with Operational Data Provisioning
  • Generic DataSources
  • Transformation and Data Transfer Process
  • Modelling Data Store Object (Advanced)
  • Transactional Data Loading from SAP source system with Operational Dat Provisioning
  • Data Loading from Flatfile
  • Modeling CompositeProviders
  • HANA Native Modeling with Calculation Views
  • Modelling Open ODS Views
  • Process Chains
  • none

SAP BW/4HANABW450
Data Acquisition

This course enables SAP BW/4HANA customers and consultants to provision ( load) data into SAP BW/4HANA. It highlights the shift to a simpler data flow required by BW/4HANA, while at the same time providing exposure and practice on utilizing load techniques targeting the underlying SAP HANA database directly. The emphasis is on learning and practicing various technologies in support of data acquisition including the traditional BW Extractors, and more recent ones like Operational Data Provisioning, Smart Data Integration and CDS views. In addition, a brief exposure to the tools SAP has to support big data will be included (SAP Data Hub).

  • Goals
  • Audience
  • Prerequisites
  • Course based on software release
  • Content
  • Notes
  • REGISTRATION

This course will prepare you to:

  • Learn how to extract data from SAP source systems and another BW with Operational Data Provisioning (ODP) and how to manage delta data with ODP
  • Acquire data from using different interfaces such as: SDI – Smart Data Integration, SDA – Smart Data Access, Flat File (with advanced techniques), and CDS views
  • Design and maintain Data Flows with advanced techniques
  • Learn about advanced features of Streaming Process Chains
  • Learn about and use the SAP HANA Source System Type
  • Gain an exposure to related provisioning technologies under the SAP Data Hub umbrella, including SAP Vora and Agile Data Preparation
Classroom
5 days
Details, Configuration & Transaction
English
SAP BW/4HANA
SAP BW/4HANA 1.0 SP05
  • Developer
  • Solution Architect
  • System Administrator
  • Technology Consultant
  • Trainer
  • Essential
    BW410 (SAP BW/4HANA Enterprise Data Warehousing )
  • Recommended
    Hands-on experience with any version of SAP BW
    BW350 (SAP BW Data Acquisition * Non HANA *
    BW430 ( SAP BW/4HANA Modeling)
    HA100 (SAP HANA Introduction)
    HA300 (SAP HANA Implementation and Data Modeling)
    HA350 (SAP HANA Data Provisioning)
  • SAP BW/4HANA 1.0 SP05
  • SAP HANA 1.0 SPS12
  • SAP BW/4HANA Modeling Tools 1.18
  • SAP HANA Data Acquisition
    • Lesson: Getting Started with the Course Landscape
    • Lesson: Explaining Data Provisioning into SAP HANA
    • Lesson: Explaining Virtual Data Provisioning into SAP HANA with Smart Data Access
    • Lesson: Data Provisioning to HANA via SLT
    • Lesson: Explaining Data Provisioning into SAP HANA via Smart Data Integration (SDI)
    • Lesson: Explaining Data Provisioning into SAP HANA via Flat Files
  • SAP BW4HANA Overview
    • Lesson: Explaining the Strategy for SAP BW/4HANA
    • Lesson: Describing the new BW/4HANA Features that affect Data Acquisition
  • Unit: Data Acquisition into BW/4HANA with the SAP HANA Source System
    • Lesson: Introducing the SAP HANA Source System
    • Lesson: Streaming Data into BW/4HANA With SDI
  • Unit: Data Acquisition into SAP BW/4HANA with Operational Data Provisioning (ODP_SAP)
    • Lesson: Describing Delta Data Acquisition and Operational Data Provisioning (ODP)
    • Lesson: Explaining ODP Source Systems of Type SAP
    • Lesson: Managing DataSources in SAP ERP Central Component (ECC) and SAP BW
    • Lesson: Managing the ODP Data Transfer Processes (DTPs)
    • Lesson: Analyzing the Operational Delta Queue (ODQ) for ODP – SAP
  • Unit: Operational Data Provisioning Delta Management (ODP_SAP)
    • Lesson: Explaining Terms and Basic Processes of Delta Enabled DataSources
    • Lesson: Configuring the Logistics Data Extraction (LO Cockpit)
    • Lesson: Discussing the “New” GL Data Extraction
    • Lesson: Configuring Generic Delta DataSources
  • Unit: SAP BW/4HANA Data Extraction from SAP S/4HANA
    • Lesson: Introducing SAP S/4HANA
    • Lesson: Describing SAP S/4HANA Analytics
    • Lesson: Understanding the positioning of SAP BW/4HANA with SAP S/4HANA
    • Lesson: Describing the SAP S/4HANA Architecture
    • Lesson: Describe ABAP CDS Views in a BW Context
    • Lesson: Understanding challenges/opportunities after updating to SAP S/4HANA
  • Unit: Other Types of Operational Data Provisioning in SAP BW/4HANA
    • Lesson: Acquiring Data from other BW-systems (ODP_BW)
    • Lesson: Extracting from ODP – SAP HANA Information Views
    • Lesson: Replicating Data with SAP Landscape Transformation Server (ODP_SLT)
    • Lesson: Comparing SAP BW Data Acquisition Options
  • Unit: Manage and Optimize Data Flow Components in SAP BW/4HANA
    • Lesson: Working with SAP HANA Optimized Transformations
    • Lesson: Positioning InfoSources
    • Lesson: Debugging Operational Data Provisioning
    • Lesson: Debugging DTPs
    • Lesson: Describe the role of the Service API and Debugging an SAP ECC DataSource
    • Lesson: Work with the Application Component Hierarchy
    • Lesson: Appending BI Content DataSources
    • Lesson: Loading Hierarchies from SAP ECC
  • Unit: Big Data Acquisition to SAP BW/4HANA and SAP Data Hub
    • Lesson: Introducing SAP Agile Data Preparation
    • Lesson: Introducing the SAP BW/4HANA Big Data Source System and SAP Vora
    • Lesson: Introducing SAP Data Hub
  • Unit: Appendix: Implementing Open Hub Destinations.
  • This course provides you a very sound foundation of newer and existing BW data acquisition concepts and contains many references to additional documents and information sources.
  • This course has a very strong focus on hands-on experience with 26 exercises.

SAP BW/4HANABW462

This course enables experienced SAP BW users, modelers as well as administrators to run and work with SAP BW/4HANA. The emphasis on how to migrate an existing SAP BW architecture and leverage new data models and functions provided by SAP BW/4HANA.

  • Goals
  • Audience
  • Prerequisites
  • Course based on software release
  • Content
  • Notes
  • REGISTRATION

This course will prepare you to:

  • Outlining advantages of the SAP “In-Memory” database foundation for SAP BW/4HANA in general.
  • Introducing new user interfaces for working with SAP BW/4HANA.
  • Enabling support for conversion projects to SAP BW/4HANA.
  • Explaining specific features as well as new data models or functions of SAP BW/4HANA also in the context of SAP´s reference architecture Layered Scalable Architecture (LSA++).
  • Explaining native HANA modeling and how both, HANA Calculation Views as well as SAP BW/4HANA objects can complement each other in so- called “mixed scenarios”.
  • Outlining Multi-Temperature data management concepts and its implementation in SAP BW/4HANA.
  • Providing an overview of all source system interfaces and data provisioning methods for loading data into SAP BW/4HANA.
  • Describing the impact SAP S/4HANA might have on your SAP BW strategy.
Virtual Live Classroom, Classroom
5 days
Details, Configuration & Transaction
English
SAP BW/4HANA
BW/4HANA 2.0 SP00
  • Application experts and consultants with a sound experience in SAP BW (non-HANA)
  • Project team members implementing and maintaining SAP BW/4HANA
  • Essential
    Several years of hands-on experience in data modeling with SAP BW 7.x
    BW310 (SAP BW Enterprise Data Warehousing non-HANA)
  • Recommended
    DBW74 (SAP BW Delta to BW 7.4 non-HANA)
    BW330 (SAP BW Data Modeling and Implementation)
    HA100 (SAP HANA Introduction)
  • SAP BW/4HANA 2.0 SP00
  • SAP HANA 2.0 SPS03
  • SAP S/4HANA 1809
  • SAP BW/4HANA Modeling Tools 1.21
  • SAP Business Objects Analysis for MS Excel 2.7
  • Getting started
    • SAP HANA
    • SAP BW/4HANA
    • SAP BW/4HANA Modeling Tools in Eclipse
    • SAP BW/4HANA Cockpit
  • Paths to SAP BW/4HANA
    • In-Place Conversion, Shell Conversion and Remote Conversion Approaches
  • SAP HANA Modeling
    • SAP HANA native Modeling of Calculation Views
    • Differences of HANA Modeling in SAP HANA 1.0 to SAP HANA 2.0
  • Core Modeling Artifacts in SAP BW/4HANA
    • Info Objects
    • Advanced DataStore-objects
    • Composite Providers
    • Open ODS Views
    • BAdI-Providers
    • Positioning of these Artifacts in the SAP Layered Scalable Architecture (LSA++)
  • Hybrid Modeling in Mixed Scenarios
    • Generation of external HANA Calculation Views for BW/4HANA Objects
    • Typical use cases for Mixed Scenarios
  • Running the SAP BW/4HANA Data Warehouse
    • Changes to Authorizations
    • Statistical Analysis in SAP BW/4HANA
    • The SAP BW/4HANA Content Add-on
    • SAP HANA Analysis Processes
    • Enhancements to the Analytic Manager
    • SAP HANA-optimized Transformations
    • Changes to Process Chains
  • SAP BW/4HANA Data Lifecycle Management
    • Multi-Temperature Data Management
    • SAP BW/4HANA Data Tiering Optimization
  • Data Provisioning into SAP HANA and SAP BW/4HANA
    • SAP LT Replication into SAP HANA
    • SAP HANA Smart Data Access
    • SAP HANA Smart Data Integration incl. real-time Streaming
    • Operational Data Provisioning based on SAP Extractors, ABAP CDS Views, HANA Information Views and BW InfoProviders
    • Integration of Big Data
  • Relevance of SAP S/4HANA to SAP BW
    • Overview of SAP S/4HANA and embedded analytics
    • Impact of SAP S/4HANA on your SAP BW strategy
  • Appendix (optional)
    • SAP BW/4HANA Workspaces
    • Mixed Scenario based on SAP Predictive Analytics
    • SAP Analytics Cloud
    • SAP BW/4HANA Tool Collection
    • Helpful Transaction Codes
  • This course provides you a very sound foundation of new BW concepts and contains many references to additional documents and information sources.
  • This course has a very strong focus on hands-on experience based on 28 exercises.

Leave a Reply

Your email address will not be published. Required fields are marked *

ABEOAbout Us
Abeo International is a leading provider in business consulting and enterprise solutions (SAP ERP) across Asia covering over 10 countries.
OUR LOCATIONSWhere to find us?
Singapore
Vietnam
Malaysia
Indonesia
USA
GET IN TOUCH
ABEOAbout us
Abeo International is a leading provider in business consulting and enterprise solutions (SAP ERP) across Asia covering over 10 countries.
OUR LOCATIONSWhere to find us?
https://mlttk3eyczgj.i.optimole.com/bJRQitU-GOKGiyIg/w:auto/h:auto/q:auto/https://abeoinc.com/wp-content/uploads/2019/12/LOGO-ABEO-VERTICAL.svg
Malaysia
Vietnam
Indonesia
India
Singapore

Copyright © 2019 ABEO Inc. All rights reserved.

Copyright © 2019 ABEO Inc. All rights reserved.