Skip to Content
Author's profile photo Martin Grob

Ruletypes and Rulegroups

Introduction

Ruletypes and Rulegroups not only define operational related definitions but also value based definitions of a transformation.

The operational related definition of the rulegroups in the transformation focuses on how the data is processed and how the datarecords go from their source structure into the target structure. Value based definitions of the transformation then actually determine the fieldvalue in the target structure.


Value based and operational related definitions

Every datarecord coming from the source structure runs through the start- and endrountine of a transformation. (Not necessarily only once!) Each of this process of the data is defined as a rulegroup.

The standard rulegroup is existing as default and it can’t be deleted but additional ones can be created. For each rulegroup there is an additional datarecord in the target structure.

The result of all rulegroups is merged in the target structure of the transformation and then posted to the target objects. (InfoCube etc.)

The number of records not necessarily multiplies by the number of rulegroups defined as the records get filtered by the identical keys. Key are created on the criteria of the  target structure/object by the system.

2013_10_20_14_47_10_Display_Transformation.png

The key fields can be seen in the transformation with a key symbol

The graphical display also shows based on which input parameters the target fieldvalue is derived from. For example if a summation is done from two keyfigures of the source to one keyfigure on the target. Two arrows from the source fields merge into the target field. Fieldvalues can be derived through:

  • Direct Assignment
  • Formula
  • No tranformation
  • Routine
  • Routine with Unit

additionally character infoobjects can:

  • Read from MasterData
  • Read From DataStore
  • Initial

All ruletypes also handle conversion exits if defined. 

Dataflow example with two rulegroups

Bildschirmfoto 2013-10-20 um 15.13.30.jpg

The example shows a split of amount between two sales groups with the help of a second rulegroup as described above.

This kind of data manipulations should only happen in the entry or datamart layer and it’s not recommended in the datawarehouse or transformationlayer as the records should be passed along without data manipulations. (Aside from deletion in start or endroutine).

The result of all rulegroups is merged in the target structure of the transformation and then posted to the target objects. (InfoCube etc.)

Assigned Tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Martin,

      Thanks for sharing this topic.

      Regards,

      Prasad

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      you're welcome

      Author's profile photo Former Member
      Former Member

      good work

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      thanks

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice Work... 🙂

      Regards,

      SM

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      always 🙂 thanks

      Author's profile photo Former Member
      Former Member

      Hi Martin,

      thanks for sharing your knowledge. Rulegroups are always a very important topic.

      A while ago, I had a roule group challenge after Dataflow migration of Cube 0PUR_C01 (Purchasing Data) http://scn.sap.com/thread/3367653 (keyword "DSO keys" 🙂 )

      Regards,

      Michael

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi

      I haven't seen that thread but I like Ethan Jewett pretty clever solution of adding a constant value to each rule group/dso key..

      Martin

      Author's profile photo Srinu S
      Srinu S

      Nice blog.Thanks for sharing. 🙂

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      thanks, you're welcome

      Author's profile photo Former Member
      Former Member

      Nice Document

      Author's profile photo Former Member
      Former Member

      Thanks for sharing the document..

      Its very helpful.. 🙂

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Martin,

      It will useful when sombody new and understand about transformation..Thanks for sharing 🙂 .

      Author's profile photo Former Member
      Former Member

      Very informative!. Thank you for sharing 🙂

      Regards

      Venkat...

      Author's profile photo Former Member
      Former Member

      Hi Martin,

      Another blog with good information. Nice.

      Author's profile photo Former Member
      Former Member

      Hi Martin,

      Nice doc... Thanks for sharing....

      Thanks,

      Chandresh Patel

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good one Martin 🙂 Thanks for sharing.

      Author's profile photo abilash n
      abilash n

      Well presented and thanks for sharing this Martin.

      Author's profile photo Former Member
      Former Member

      Nice doc Martin. 🙂

      Regards,

      Poorna

      Author's profile photo Phani KV
      Phani KV

      Hi,

      Nice document and thanks for sharing.

      Thanks,

      Phani.

      Author's profile photo Former Member
      Former Member

      Good,keep it up.