/
Browse
/
Courses
/
Implementing Modeling Scenarios in SAP BW/4HANA
/
Implementing Data Models for Master Data in SAP BW/4HANA
Identifying a Business Case for Data Modeling
Describing the ItelO Company
6 min
Identify Motivation and Challenges in Data Modeling
30 min
Describe the Source System Data Model
15 min
Quiz
Identifying Modeling Approaches of SAP S/4HANA, SAP HANA and SAP BW/4HANA
Identifying Key Aspects of SAP S/4HANA embedded analytics
16 min
Identifying Key Aspects of SAP HANA Modeling
10 min
Identifying Key Aspects of SAP BW/4HANA Modeling
10 min
Comparing Modeling Focus of SAP BW/4HANA, SAP HANA and SAP S/4HANA
20 min
Quiz
Describing the Process of Modeling in SAP BW/4HANA
Explaining the Sequence of SAP BW/4HANA Projects and the Phases of an SAP BW/4HANA Project
16 min
Identify Approaches to Create an SAP BW/4HANA Data Model
10 min
Create a Key Figure Matrix and Architecture Overview
40 min
Create a Logical Data Model and a Detailed Data Model
40 min
Use BI Content
30 min
Identifying the System Landscape
10 min
Quiz
Implementing Data Models for Master Data in SAP BW/4HANA
Identify the Relationship Between Master Data and Transactional Data
30 min
Explore Tables of a Master Data-Bearing Characteristic
30 min
Identify Tracking History Scenarios
40 min
Identify Modeling Scenarios for Hierarchies
20 min
Implement Scenarios Related to Master Data
10 min
Implement Changes to Master Data
10 min
Quiz
Implementing Data Models for Transactional Data in SAP BW/4HANA
Identify the SAP BW/4HANA Layered Scalable Architecture (LSA++)
31 min
Use Modeling Options to Integrate Data from Different Sources
30 min
Use Different Types of DataStore Objects (advanced)
1 hr
Maintaining DataStore Objects (advanced)
15 min
Use Modeling Options with InfoSources
15 min
Model Currency Translation and Unit Conversion
55 min
Use Modeling Options with CompositeProviders
1 hr 5 min
Quiz
Implementing Field-Based Modeling Scenarios in SAP BW/4HANA
Compare Field-Based Modeling with InfoObject-Based Modeling
11 min
Use Field-Based Modeling in Virtual Data Consumption Scenarios
40 min
Use Field-Based Modeling in Snapshot Scenarios
25 min
Quiz
Implementing Modeling Scenarios Using SAP HANA
Set Up SAP Web IDE for SAP HANA for SAP HANA Modeling
26 min
Identify Types of SAP HANA Calculation Views
20 min
Create Calculation Views Related to Master Data
20 min
Create Calculation Views Related to Transactional Data
40 min
Generate SAP HANA Calculation Views from SAP BW/4HANA objects
20 min
Implement Mixed Scenarios Using SAP HANA Modeling and SAP BW/4HANA
30 min
Quiz
Identifying a Business Case for Data Modeling
Describing the ItelO Company
6 min
Identify Motivation and Challenges in Data Modeling
30 min
Describe the Source System Data Model
15 min
Quiz
Identifying Modeling Approaches of SAP S/4HANA, SAP HANA and SAP BW/4HANA
Identifying Key Aspects of SAP S/4HANA embedded analytics
16 min
Identifying Key Aspects of SAP HANA Modeling
10 min
Identifying Key Aspects of SAP BW/4HANA Modeling
10 min
Comparing Modeling Focus of SAP BW/4HANA, SAP HANA and SAP S/4HANA
20 min
Quiz
Describing the Process of Modeling in SAP BW/4HANA
Explaining the Sequence of SAP BW/4HANA Projects and the Phases of an SAP BW/4HANA Project
16 min
Identify Approaches to Create an SAP BW/4HANA Data Model
10 min
Create a Key Figure Matrix and Architecture Overview
40 min
Create a Logical Data Model and a Detailed Data Model
40 min
Use BI Content
30 min
Identifying the System Landscape
10 min
Quiz
Implementing Data Models for Master Data in SAP BW/4HANA
Identify the Relationship Between Master Data and Transactional Data
30 min
Explore Tables of a Master Data-Bearing Characteristic
30 min
Identify Tracking History Scenarios
40 min
Identify Modeling Scenarios for Hierarchies
20 min
Implement Scenarios Related to Master Data
10 min
Implement Changes to Master Data
10 min
Quiz
Implementing Data Models for Transactional Data in SAP BW/4HANA
Identify the SAP BW/4HANA Layered Scalable Architecture (LSA++)
31 min
Use Modeling Options to Integrate Data from Different Sources
30 min
Use Different Types of DataStore Objects (advanced)
1 hr
Maintaining DataStore Objects (advanced)
15 min
Use Modeling Options with InfoSources
15 min
Model Currency Translation and Unit Conversion
55 min
Use Modeling Options with CompositeProviders
1 hr 5 min
Quiz
Implementing Field-Based Modeling Scenarios in SAP BW/4HANA
Compare Field-Based Modeling with InfoObject-Based Modeling
11 min
Use Field-Based Modeling in Virtual Data Consumption Scenarios
40 min
Use Field-Based Modeling in Snapshot Scenarios
25 min
Quiz
Implementing Modeling Scenarios Using SAP HANA
Set Up SAP Web IDE for SAP HANA for SAP HANA Modeling
26 min
Identify Types of SAP HANA Calculation Views
20 min
Create Calculation Views Related to Master Data
20 min
Create Calculation Views Related to Transactional Data
40 min
Generate SAP HANA Calculation Views from SAP BW/4HANA objects
20 min
Implement Mixed Scenarios Using SAP HANA Modeling and SAP BW/4HANA
30 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 7 right to pass this unit.
1.
As long as the InfoObject contains data, it's not possible to remove compounded fields.
Choose the correct answer.
True
False
2.
Which of the following statements regarding internal and external hierarchies are true?
There are three correct answers.
Internal hierarchies have no link to master data tables.
Internal hierarchies are used to display characteristics without using an external hierarchy.
External hierarchies are defined in BW Modeling Tools on the Hierarchy tab of a Query.
External hierarchies are stored in SAP BW/4HANA master data tables.
3.
You have created a reference characteristic 0SOLD_TO based on referenced characteristic 0BPARTNER. You can change the description of reference characteristic 0SOLD_TO.
Choose the correct answer.
True
False
4.
Why would you recommend a separation of master data and transactional data?
There are two correct answers.
No joins are needed for reporting.
This usually reduces the size of the physical storage.
You improve consistency in the enterprise data warehouse.
This is a prerequisite for currency conversion.
5.
You use Customer and Booking Date as characteristics together with the key figure Amount in a DataStore Object (advanced). The customer has a time-dependent attribute Customer Class, which is not part of this model. What can you do to see the historical truth in a report that shows Customer, Customer Class, Booking Date, and Amount?
There are two correct answers.
You do not need to change anything: the historical truth is shown.
Add Customer Class as a navigation attribute of Customer.
Remodel the DataStore Object (advanced) and add a characteristic Customer Class in the DataStore Object (advanced) model. Fill the new column with a lookup from the InfoObject Customer, based on Booking Date.
Create a CompositeProvider with a temporal join for characteristic Customer, with reference to Booking Date. Make sure that Customer Class is added to the target structure.
6.
Time-dependent and time-independent attributes are stored in the same X table which uses Date From and Date To as key fields.
Choose the correct answer.
True
False
7.
In the SAP BW/4HANA data model, master data is stored separately in attribute, text, and hierarchy tables that are linked together using the surrogate ID (SID).
Choose the correct answer.
True
False
8.
To model the tracking history scenarios of historical truth and current truth, two different star schemas are required.
Choose the correct answer.
True
False