SAP BW/4HANA Data Modeling

Popis kurzu

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.

Goals:

• 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

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.

Goals:

• 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

Určeno pro

• Application Consultant


• Business Analyst


• Solution Architect


• System Architect


• Technology Consultant

Obsah kurzu

• 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

Předpoklady

Essential

• Hands-on experience in data warehousing with SAP BW/4HANA


• BW410 (SAP BW Enterprise Data Warehousing with SAP BW/4HANA)

Recommended

• HA100 (SAP HANA Introduction)

Studijní materiály

Návaznosti

• 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