Course announcements

  • This course is designed for users with some experience in BW/4HANA or for users who have visited BW410 who know the BW/4HANA terms and basic data warehousing tasks. They learn to design a LSA++ layered architecture model and BW/4HANA object models. Focus topics are master data (especially hierarchies), open ODS views, Composite Providers, staging scenarios with InfoSource, Calculation views, BW Workspaces, currency and unit conversion.

Goals

  • Outlining advantages of the new SAP “In-Memory” database foundation for SAP BW in general.
  • Understanding modeling requirements.
  • Best Practices guidelines such as separating master data and transactional data, LSA++ for SAP BW/4HANA, partitioning.
  • Describing steps in designing an architecture overview and a detailed data model.
  • Comparing BI Content with requirements
  • Explaining field-based modeling.
  • Creating hierarchies with BW/4HANA InfoObjects or native SAP HANA calculation views
  • Master data reporting using hierarchies
  • Harmonizing transactional data from two different sources
  • Currency Conversion in BW/4HANA transformations or in native SAP HANA calculation views
  • Generating external HANA views, and designing “mixed scenarios”.
  • Implementing HANA Analysis Processes.
  • Designing Inventory Management
  • Designing Stock coverage scenarios

Audience

  • Application experts and consultants with a basic experience in SAP BW/4HANA
  • Project team members implementing and maintaining SAP BW/4HANA

Prerequisites

Essential

  • Hands-on experience in data warehousing with SAP BW/4HANA
  • BW410(SAP BW Enterprise Data Warehousing with SAP BW/4HANA)

Recommended

  • HA100(SAP HANA Introduction)
  • HA350(SAP HANA Data Provisioning)

Course based on software release

  • SAP BW/4HANA 1.0 SP02
  • SAP HANA 1.0 SPS12
  • SAP BW/4HANA Modeling Tools 1.1
  • SAP BusinessObjects Analysis for MS Excel 2.2

Content

  • Challenges for Data Modeling
    • Introduction to Data Modelling
    • Solving Requirement Conflicts
  • Overview about the Business Case
    • Getting to know the ItelO Case Study
    • Understanding the Source Model
  • Modeling Approaches in SAP BW/4HANA
    • Introducing SAP HANA modeling
    • Advantages and issues of SAP BW modeling
    • Comparing SAP BW/4HANA focus, SAP HANA focus and mixed strategies
  • Best Practice Standards in BW/4HANA Modeling
    • Optional: Understanding Object Changeability
    • Separating Master Data and Transactional Data
    • Tracking history
    • Mapping and Transforming Data
    • Designing a Layered Scalable Architecture with Virtual Layers (LSA+
    • Understanding Physical and Logical Partitioning
  • Process of Modeling
    • Defining the Sequence of SAP BW/4HANA Projects
    • Planning the Phases of a SAP BW/4HANA Project
    • Performing a Requirement Analysis
    • Creating an Architecture Overview
    • Creating a Logical Data Model
    • Developing a SAP BW/4HANA Data Model
  • as
    • Working with SAP Business Content
    • Introducing ABAP CDS Views provided by SAP BW/4HANA
  • Implementing Native SAP HANA Views
    • Modeling Master Data
    • Modeling Transactional Data
  • Implementing SAP BW/4HANA Field-Based Rapid Prototyping
    • Implementing Field-Based Modeling with Open ODS Views
    • Implementing Snapshot and Corporate Memory Models with Advanced DataStore Objects
  • Implementing Models in SAP BW/4HANA
    • Modeling and Implementing SAP BW/4HANA Master Data
    • Modeling and Implementing InfoSources
    • Modeling and Implementing Advanced DataStore Objects (ADSOs)
    • Modeling and Implementing Transformations
    • Modeling and Implementing CompositeProviders
  • Implementing Agile Data Marts
    • Generating External SAP HANA Views
    • Enhance an External SAP HANA View
  • Implementing SAP BW/4HANA Workspaces
    • Defining a Workspace
    • Implementing Local Composite Providers
  • Advanced Modeling in SAP BW/4HANA
    • Introducing the HANA Analysis Process (HAP)
    • Defining Inventory Scenarios
    • Stock Coverage
    • Planning Mode
    • Additional Sources of Information