- This course is designed for users with some experience in BW/4HANA or for users who have visited BW410 and know the BW/4HANA terms and basic data warehousing tasks. They learn to design BW/4HANA data models based on the LSA++ layered scalable architecture model and using SAP BW/4HANA and SAP HANA modeling objects. Focus topics are master data (especially time-dependency and hierarchies), Open ODS Views, different types of Advanced DataStore Objects, and different Composite Provider scenarios, staging scenarios with InfoSources, currency and unit conversion, and hybrid models with SAP HANA Calculation views.
- Introduction to Data Modelling, Challenges, Conflicts
- Overview about the Business Case (Case Study)
- Comparing Modeling approaches
- SAP HANA modeling
- SAP BW/4HANA modeling
- Mixed strategies
- Best Practice Standards in BW/4HANA Modeling
- Understanding Object Changeability
- Separating Master Data and Transactional Data
- Using Time-Dependent Master Data, Tracking History
- Harmonizing Data
- Designing a BW/4HANA Layered Scalable Architecture (LSA++)
- Understanding Physical and Logical Partitioning
- Process of Modeling
- Defining the Sequence and Phases of SAP BW Projects
- Developing an SAP BW/4HANA Data Model
- SAP BW/4HANA Content Add-On
- Working with SAP Business Content
- Introducing ABAP CDS Views provided by SAP BW/4HANA
- Implementing SAP BW/4HANA Field-Based Models
- Implementing Field-Based Modeling with Open ODS Views
- Understanding Snapshot and Corporate Memory Models
- Implementing Models in SAP BW/4HANA
- Modeling and Implementing SAP BW/4HANA Master Data
- Modeling and Implementing Advanced DataStore Objects (ADSOs)
- Modeling and Implementing InfoSources and Transformations
- Modeling and Implementing Composite Providers
- Implementing Native SAP HANA Views
- Modeling Master Data in SAP HANA Views
- Modeling Transactional Data in SAP HANA Views
- Implementing Agile Data Marts
- Generating External SAP HANA Views for SAP BW/4HANA Objects
- Implementing Mixed Scenarios
- Additional Modeling aspects in SAP BW/4HANA
- Introducing the HANA Analysis Process (HAP)
- Defining Inventory Scenarios
- Defining Stock Coverage Scenarios
- Outlining advantages of the new SAP "In-Memory" database foundation for SAP BW in general.
- Understanding modeling requirements and comparing modeling approaches
- Discussing Best Practices guidelines such as LSA++ and separating master and transactional data.
- Describing steps in developing an SAP BW/4HANA data model.
- Applying SAP Business Content.
- Using the power of SAP BW/4HANA modeling artifacts.
- Leveraging the advantages of field-based modeling.
- Creating and using hierarchies with SAP BW/4HANA InfoObjects or with native SAP HANA Calculation Views.
- Harmonizing transactional data from different source systems.
- Implementing Currency and Unit Conversion with SAP BW/4HANA or with native SAP HANA Calculation Views.
- Generating external HANA views and understanding "Mixed Scenarios".
- Creating and using an SAP HANA Analysis Process.
- Outlining Inventory Management and Stock coverage scenarios
- Application Consultant
- Business Analyst
- Solution Architect
- System Architect
- Technology Consultant
- SAP HANA 2.0 SP04
- SAP S/4HANA 1909 FP01
- SAP BW/4HANA 2.0 SP04
- SAP HANA Studio 2.3.51
- SAP BW/4HANA Modeling Tools 1.22.17
- BI Platform 4.2 SP07
- SAP Analysis for Microsoft Office 2.7
- SAP Lumira (Discovery & Designer) Lumira 2.3 SP03
- SAP Analytics Cloud
- SAP NW Business Client 5.0
- This course provides you a very sound foundation of BW/4HANA modeling concepts and contains references to additional documents and information sources.
- This course has a focus on presenting concepts and a variety of hands- on-tasks partially based on a case study. The trainer will choose 20 – 30 suitable exercises out of more than 30 available exercises.
Find a course date
Can't find a suitable date?
Booking for 1-2 people?
Make a request for us to schedule training around what works for you? We will do our best to consider your request.Request a training date
Booking for 3+ people?
Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.Find out more