Showing posts with label transformation rule group. Show all posts
Showing posts with label transformation rule group. Show all posts

Wednesday, October 13, 2021

RULE GROUP IN BW TRANSFORMATION

A rule group is a group of transformation rules. It contains one transformation rule for each key field of the target. A transformation can contain multiple rule groups.

Rule groups allow you to combine various rules. This means that for a characteristic, you can create different rules for different key figures.

Each transformation initially contains a standard group. Besides this standard group, you can create additional rule groups.

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.  


SCENARIO: Let's consider a scenario where we have multiple keyfigure(SALESQ1-4 in this case) and you need to bring each to new row based on the key(Calyear). Then we can create rule group for this scenario. Below is the source data and we are going to implement rule group and split each Store to 4 records.


Complete the logic for standard group
Create 3 more rule group for each Quarter data, activate the transformation , DTP and  execute the DTP.
Below is the target data we will get after loading 


Input parameter:

Featured Post

Extending/Increasing Key figure Length with custom Domain

  In this Post, We will learn how to increase Key figure length with new domain or custom Domain.   Go to RSD1 Tcode and enter NOHDB Tcode...

Popular Posts