Goals

  • Learn procedures within modeling of SAP Business Warehouse
  • Learn how to create a Layered Scalable Architecture

Audience

  • Application Consultant
  • Business Analyst
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Enterprise Architect
  • Program / Project Manager
  • Technology Consultant

Prerequisites

Essential

  • BW310
  • Basic knowledge of data modeling

Recommended

  • None

Course based on software release

  • • SAP Business Warehouse 7.4

Content

  • Enterprise Data Warehouse (EDW) Architecture
    • Determining EDW Architecture
    • Planning the Architecture of an EDW
    • Using the EDW Layers
    • Determining the Purpose of the Data Mart Layers
    • Determining the Purpose of the Operational Data Store Layer
  • The Modeling Process
    • Identifying Decision Areas within SAP BW Projects
    • Performing Requirements Analysis
    • Creating a Logical Data Model
    • Developing the SAP BW Data Model
    • Creating Graphical Data Models and Templates
  • Data Modeling Practice
    • Drafting a Data Model
    • Summarizing Data Modeling Practice
  • BI Content Analysis
    • Listing the Uses of BI Content
    • Comparing a Data Model with BI Content
  • InfoObject Models
    • Listing the Tables in the SAP BW Data Model
    • Implementing Tracking History Scenarios
    • Using Reference Characteristics
    • Using Hierarchies
    • Using Key Figures
    • Creating Translation Types for Currency Translation
    • Creating Translation Types for Quantity Conversion
    • Creating a Data Model for Mapping Non-Cumulative Values in SAP BW
  • Modeling DataStore Objects
    • Modeling DataStore Objects
    • Using Real Time Data Acquisition (RDA)
  • Multi-Dimensional Modeling
    • Determining the SAP BW Star Schema
    • Designing the Dimensions of the SAP BW InfoCube
  • Enhanced InfoProvider Modeling
    • Modeling MultiProviders
    • Modeling an SPO
    • Modeling an InfoSet
    • Modeling a VirtualProvider
    • Modeling a HybridProvider
    • Explaining InfoProviders in SAP BW and the InfoProvider Decision Tree
  • Data Model Remodeling
    • Modifying a Data Model
  • Information Lifecycle Management
    • Describing Information Lifecycle Management
  • LSA++ with SAP BW on SAP HANA
    • Determining the Advantages of SAP BW on SAP HANA
    • Determining the Enhancements of LSA++ with SAP HANA