+353 1 279 0020 and +353 86 2471404sales@olas.ie Olas: Professional, Direct, Clever & Helpful

BW330H: SAP BW powered by SAP HANA: Data Warehouse Modeling


This course will prepare learners to:

  • Learn the procedures within modeling of the BW Enterprise Data Warehouse and acquire deep knowledge about modeling and implementation of data warehousing with SAP BW 7.5.
  • Learn how to create a Layered Scalable Architecture.


Price per Person: Click Here


Click Here



  • Project team members with basic knowledge of Data Warehousing and SAP ERP experience



  • Learners should having taken SAP Course BW310H:SAP BW powered by SAP HANA: Enterprise Data Warehousing
  • Basic knowledge of data modeling


  • None
  • This course contains only an overview over the Layered Scalable Architecture++ with SAP HANA, with some example LSA++ and SAP HANA modeling exercises. It is no substitute for a project consulting.
  • This course does not discuss operational solutions or specific technical company scenarios.
  • Courseware available as flipbook in Learning Hub>
  • Course based on software release

    • SAP BW 7.5 powered by SAP HANA
Course Outline
  • Data Modeling with SAP Business Information Warehouse (SAP BW) Powered by SAP HANA
    • Understanding Modeling Targets and Issues
    • Understanding SAP HANA From a Modeling Perspective
    • Understanding SAP BW From a Modeling Perspective
    • Comparing SAP BW with SAP HANA
    • Understanding the Strategy for SAP BW on SAP HANA
  • Business Review
    • Mapping Current Processes
    • Getting to Know the ITelO Case Study
    • Understanding the Relevant Skills and Exercises
  • Global Decision Areas and Best Practice Standards
    • Evaluating Global Standards and Local Adaptations
    • Planning Transport Management
    • Separating Master Data and Transactional Data
    • Designing a Layered Scalable Architecture (LSA) with Virtual Layers
    • Understanding Scenarios for SAP BW on SAP HANA
    • Understanding LSADomains
    • Understanding Reporting Options
  • Process of Modeling
    • Defining the Sequence of SAP BW Projects
    • Planning the Phases of a SAP BW Project
    • Creating a Logical Data Model
    • Developing a SAP BW Data Model
  • Field-Based Rapid Prototyping
    • Getting an Overview SAP HANA Live
    • Overviewing Business Content
    • Implementing Field-Based Modeling
  • Master Data Modeling in SAP HANA Views
    • Using Hierarchies in SAP HANA Views
  • Transaction Data Modeling with SAP HANA
    • Using Measures in SAP HANA Views
  • Master Data Modeling with SAP BW Characteristics
    • Listing Tables in the SAP BW Data Model
    • Using Reference Characteristics
    • Using Hierarchies in SAP BW Characterisitcs
  • Key Figure Modeling in SAP BW
    • Defining Key Figures as InfoObjects
    • Creating Translation Types for Currency Translation
    • Creating Translation Types for Quantity Conversion
    • Creating a Data Model for Calculating Stock Coverage
    • Creating a Data Model for Non-Cumulative Values
  • Transactional Data Modeling in SAP BW
    • Modeling Advanced DataStore Objects (ADSOs)
    • Modeling a Composite Provider for Agile Data Mart Scenarios
    • Implementing Tracking History Scenarios
    • Modeling Transformations
  • Hybrid Modeling in Mixed Scenarios
    • Modeling Mixed Scenarios
    • Enhancing Views in SAP HANA
  • Areas of SAP BW Workspaces
    • Modeling a Workspace
  • Enhanced Scenarios in SAP BW
    • Implementing Enhanced Scenarios
  • Existing Model Enhancement
    • Converting Silos or LSAs to LSA
    • Using the SAP BW Remodeling Toolbox
    • Remodeling with an SPO in SAP BW
  • Optional: SAP BW Data Management
    • Implementing Dynamic Tiering
    • Implementing Lifecycle Management and Near-Line Storage (NLS)
Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.