/
Browse /
Courses /
Implementing a Data Warehouse Using SAP BW/4HANA /
Exploring Additional Options With Transformations

Introducing Data Warehousing in SAP BW/4HANA

Introducing Enterprise Data, SAP BW/4HANA and the Role of SAP HANA in SAP BW/4HANA30 min
Working with SAP BW/4HANA Tools20 min
Introducing a Data Warehousing Scenario20 min
Quiz

Modeling InfoObjects in SAP BW/4HANA

Introducing InfoObjects15 min
Defining Characteristics40 min
Defining Key Figures15 min
Quiz

Modeling Data Flows

Introducing Data Flow Modeling5 min
Introducing Graphical Data Flow Modeling15 min
Quiz

Loading Master Data to SAP BW/4HANA

Introducing ODP20 min
Creating ODP_SAP DataSources20 min
Replicating ODP_SAP DataSources15 min
Creating Transformations and Data Transfer Processes15 min
Executing Data Transfer Processes and Exploring Master Data20 min
Quiz

Modeling DataStore Objects (advanced) in SAP BW/4HANA

Introducing DataStore Objects (advanced)15 min
Using the Data Mart DataStore Object35 min
Using the Standard DataStore Object35 min
Using the Staging DataStore Object10 min
Quiz

Loading Transactional Data to SAP BW/4HANA

Loading Transactional Data from SAP S/4HANA30 min
Loading Transactional Data from a Flat File50 min
Updating Transactional Data in a Standard DataStore Object25 min
Quiz

Exploring Additional Options With Transformations

Introducing InfoSources10 min
Using Transformation Rules20 min
Using Rule Groups10 min
Using Start Routine, End Routine and Expert Routine25 min
Identifying Runtime in Transformations10 min
Quiz

Modeling Open ODS Views

Introducing Open ODS Views40 min
Using Open ODS Views in Modeling Scenarios30 min
Loading Data Based on an Open ODS View25 min
Quiz

Modeling CompositeProviders and Queries

Introducing CompositeProviders35 min
Introducing Queries20 min
Quiz

Exploring Administrative and Operational Activities Related to Data Loading

Administrating Master Data10 min
Administrating DataStore Objects (advanced)40 min
Using Process Chains45 min
Describing SAP HANA Delta Merge Related To SAP BW/4HANA25 min
Quiz

Introducing Data Warehousing in SAP BW/4HANA

Introducing Enterprise Data, SAP BW/4HANA and the Role of SAP HANA in SAP BW/4HANA30 min
Working with SAP BW/4HANA Tools20 min
Introducing a Data Warehousing Scenario20 min
Quiz

Modeling InfoObjects in SAP BW/4HANA

Introducing InfoObjects15 min
Defining Characteristics40 min
Defining Key Figures15 min
Quiz

Modeling Data Flows

Introducing Data Flow Modeling5 min
Introducing Graphical Data Flow Modeling15 min
Quiz

Loading Master Data to SAP BW/4HANA

Introducing ODP20 min
Creating ODP_SAP DataSources20 min
Replicating ODP_SAP DataSources15 min
Creating Transformations and Data Transfer Processes15 min
Executing Data Transfer Processes and Exploring Master Data20 min
Quiz

Modeling DataStore Objects (advanced) in SAP BW/4HANA

Introducing DataStore Objects (advanced)15 min
Using the Data Mart DataStore Object35 min
Using the Standard DataStore Object35 min
Using the Staging DataStore Object10 min
Quiz

Loading Transactional Data to SAP BW/4HANA

Loading Transactional Data from SAP S/4HANA30 min
Loading Transactional Data from a Flat File50 min
Updating Transactional Data in a Standard DataStore Object25 min
Quiz

Exploring Additional Options With Transformations

Introducing InfoSources10 min
Using Transformation Rules20 min
Using Rule Groups10 min
Using Start Routine, End Routine and Expert Routine25 min
Identifying Runtime in Transformations10 min
Quiz

Modeling Open ODS Views

Introducing Open ODS Views40 min
Using Open ODS Views in Modeling Scenarios30 min
Loading Data Based on an Open ODS View25 min
Quiz

Modeling CompositeProviders and Queries

Introducing CompositeProviders35 min
Introducing Queries20 min
Quiz

Exploring Administrative and Operational Activities Related to Data Loading

Administrating Master Data10 min
Administrating DataStore Objects (advanced)40 min
Using Process Chains45 min
Describing SAP HANA Delta Merge Related To SAP BW/4HANA25 min
Quiz

Knowledge quiz

It's time to put what you've learned to the test, get 4 right to pass this unit.

1.

Which of the following rule types in a Transformation do not need entering ABAP code?

There are three correct answers.

Look Up InfoObject

Time Conversion

Routine

Formula

2.

Why do you implement an InfoSource?

Choose the correct answer.

To store data at the most detailed level

To provide a modeling object that is accessed by Queries

To break up transformations into several layers

3.

Which transformation option can be used to delete records that are not required for updating?

Choose the correct answer.

Start Routine

End Routine

Time broadcasting

Initial

4.

For which scenario would you use an additional rule group in a Transformation?

Choose the correct answer.

The update of a particular Key Figure depends on the Characteristics involved

To use multiple Transformations when executing a Data Transfer Process

To use the same Transformation for multiple DataStore Objects (advanced)

5.

Which objects can be used as a target in a Transformation?

There are two correct answers.

InfoSource

DataSource

Data Mart DataStore Object