sap-training-courses
7862  Reviews star_rate star_rate star_rate star_rate star_half

SAP BW powered by SAP HANA: Data Warehouse Modeling

Skills Gained This course will prepare you to: -Learn procedures within modeling of SAP Business Warehouse -Learn how to create a Layered Scalable Architecture Who Can Benefit Application Consultant...

Read More
Course Code BW330H-v017
Duration 5 days
Available Formats Classroom

Skills Gained

  • This course will prepare you to:
       -Learn procedures within modeling of SAP Business Warehouse
       -Learn how to create a Layered Scalable Architecture

Who Can Benefit

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

Prerequisites

  • Essential:
       -BW310H
       -Basic knowledge of data modeling
  • Recommended:
       -None

Course Details

Course Content

  • 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
  • Business Review
       -Understanding the Relevant Skills and Exercises
       -Getting to know the ITelO Case Study
       -Understanding the ERP Model
  • Global Decision Areas and Best Practice Standards
       -Planning Transport Management
       -Separating Master Data and Transactional Data
       -Tracking History
       -Evaluating Global Standards and Local Adaptations
       -Designing a Layered Scalable Architecture (LSA) with Virtual Layers
       -Understanding LSADomains
       -Understanding Reporting Options
  • Process of Modeling
       -Defining the Sequence of SAP BW Projects
       -Planning the Phases of a SAP BW Project
       -Developing a SAP BW Data Model
       -Getting an Overview SAP HANA Live
       -Overviewing Business Content
  • Field-Based Rapid Prototyping
       -Implementing Field-Based Modeling
  • Master Data Modeling with SAP BW Characteristics
       -Listing Tables in the SAP BW Data Model
       -Using Reference Characteristics
       -Using Hierarchies in SAP BW Characteristics
  • Key Figure Modeling in SAP BW
       -Defining Key Figures as InfoObjects
       -Creating Key figures for Non-Cumulatives
  • Transactional Data Modeling in SAP BW
       -Modeling Advanced DataStore Objects (ADSOs)
       -Implementing Currency Harmonization
       -Implementing Quantity Conversion
       -Modeling Transformations
       -Modeling a Composite Provider for Agile Data Mart Scenarios
  • Master Data Modeling in SAP HANA Views
       -Modeling Master Data and Hierarchies in SAP HANA Views
  • Transaction Data Modeling with SAP HANA
       -Modeling Transactional Data in SAP HANA Views
  • Hybrid Modeling in Mixed Scenarios
       -Modeling Mixed Scenarios
       -Enhancing Views in SAP HANA
  • Enhanced Scenarios in SAP BW
       -Modeling an SAP BW Workspace
       -Implementing HANA Analysis Processes
  • Existing Model Enhancement
       -Using the SAP BW Remodeling Toolbox
       -Converting Silos or LSAs to LSA

Notes

  • 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.

Course based on software release

  • BW 7.5 SP04
  • SAP HANA 1.0 SPS 12
  • BIP 4.1 SP07