Introducing Data Warehousing in SAP BW/4HANA
Modeling InfoObjects in SAP BW/4HANA
Modeling Data Flows
Loading Master Data to SAP BW/4HANA
Modeling DataStore Objects (advanced) in SAP BW/4HANA
Loading Transactional Data to SAP BW/4HANA
Exploring Additional Options With Transformations
Modeling Open ODS Views
Modeling CompositeProviders and Queries
Exploring Administrative and Operational Activities Related to Data Loading

Using Rule Groups

Objective

After completing this lesson, you will be able to use rule groups.

Rule Groups in a Transformation

Use of a Rule Group

Target sits above an orange Transformation zone containing expert, end and start routines, transformation rules and rule groups; blue Packages feed the Extraction Group signal.

A rule group is a group of transformation rules within a Transformation. A rule group contains one transformation rule for each key field of the target. Each Transformation initially contains a standard rule group.

Screenshot of SAP transformation rule configuration: shows existing standard group, option to add more rule groups (e.g., Rule Group 2), and the new group's rules.

Besides this standard group, you can create additional rule groups. For a Characteristic, you can create different rules for different Key Figures.

Diagram shows data transformation: input table with Johnson, 1,000, Giles; two rule groups compute bonuses (20% of employee sales; 5% of manager sales) producing records.

A use case for an additional rule group would be the update of a particular Key Figure that depends on the Characteristics involved. For example, the bonus of an employee's manager is calculated in a different way than for the employee who generated sales volume.

In the figure above, the field Bonus is calculated in a different way for the Manager compared to the Employee.

Note

If you have defined a new rule in rule details, you can specify whether this rule is to be used as a reference rule for other rule groups. If it is used as a reference rule, then this rule is also used in existing rule groups as a reference rule where no other rule has been defined.