Rule Groups in Transformation
A rule group is a group of transformation rules. It contains one transformation rule for each key Figure of the target.
A transformation can contain multiple rule groups.
Rule groups allows to combine various rules. This means that for a characteristic, we can create different rules for different key figures
Each transformation initially contains a standard group. Besides this standard group, we can create additional rule groups.
If we have defined a new rule in rule details, we 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.
Few key points about Rule Groups:
1. A transformation can contain multiple rule groups.
2. A default rule group is created for every transformation called as Standard Group. This group contains all the default rules.
3. Standard rule group cannot be deleted. Only the additional created groups can be deleted.
Step by Step Procedure to create rule groups:
Step1: Create Data Source (Refer Fig 1 of attachment). Here i have created a Flat-file data source.
Step2: Create the flat file. I have created a flat file with two fields NAME and NUMBER. (refer Fig2 of attachment).
Step3: The DSO used has 4 fields
Key Field- Name ( ZNAME)
Data Field- Number (ZNUM)
Key Figures- Filled on RG1/RG2 (ZRG2) & Filled on RG1(ZRG1)
Step4: In the standard rule Group, we have defined the rule for ZRG1 (Refer Fig3 of attachment)
Step5: Fig 4 shows the code used in transformation for ZRG1.
Step6: Rule Group2 is defined for ZRG2 (Fig 5).
Step7: Fig 5 shows the code used in transformation for ZRG2.
Step8: perfom the load by executing the DTP.
Step9: fig6 shows the result of data load.