Skip to Content
Author's profile photo Former Member

Rule Groups in Transformation

Rule Group

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

Features

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.

Document Attached.

 
 
  References:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90754b76-bcf1-2a10-3ba7-b299b2be09f2?quicklink=index&overridelayout=true

Rule Group (SAP Library – Business Intelligence)

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Matthew Billingham
      Matthew Billingham

      Don't have content in attachments. Further this blog is not of a standard to be approved. You may re-create as a personal blog if you wish.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Matthew,

      It does not allow to paste screen shots in the text area, so i have attached the steps as a document. Is it not okay?

      I will try updating the document and pubishing it again.

      Thanks in advance!!

      Regards,

      Kavita.

      Author's profile photo Matthew Billingham
      Matthew Billingham

      They are not even screen shots. Since when has text been a part of a screen shot?