COURSE OBJECTIVES
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
TARGET AUDIENCE
- Project team members with basic knowledge of Data Warehousing and SAP ERP experience
PREREQUISITES
Essential
- Learners should having taken SAP Course BW310H:SAP BW powered by SAP HANA: Enterprise Data Warehousing
- Basic knowledge of data modeling
Recommended
- None
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.
- Courseware available as flipbook in Learning Hub>
- SAP BW 7.5 powered by SAP HANA
Course based on software release
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)