Transformation Rule Group /Type

[p_m8]

Gurus,

In BI7, we’re now using Transformation instead of Transfer /Update Rule.

Noticed that there is Rule Group and Rule Type feature there, does anyone know how to use this?

Please provide some example.

Thanks in advance.

[Former Member]

Philip,

As SAP HELP says it just a group of transformation rules. if you want to apply different business rules to one target key field(characteristic) you can use different rule groups. All rules of all groups are executed at the same time.

[p_m8]

Hi manyam,

theorically yes, but technically how exactly we should create this Transformation?

Take the example from SAP help file, exactly how we do this? Especially on the (depending on the key figure, update the order date, delivery date, or invoice date to the target....). Where we put the "If else statement"?

need your help pleae...

======

The source contains three date characteristics:

● Order date

● Delivery date

● Invoice date

The target only contains one general date characteristic. Depending on the key figure, this is filled from the different date characteristics in the source.

Create three rule groups which, depending on the key figure, update the order date, delivery date, or invoice date to the target.

=====

[Former Member]

Hi,

There are two rule group one standard and other one is technical rule.

Standard rule contains all the source and target field mapping details expect the 0RECORDMODE mapping.

Technical Rule will have 0RECORDMODE mapping only.

When you are creating a transformation which contains Data source fields on the left hand side and Data target fields on the right hand side. Standard rule will allow you to drag and map the field to field .

Rule Type is similar to Transfer rule / Update rule type like Direct assignment ,Constant,Formula,initial , read Master data and Routine.

Whenever you created a routine or if some fields in the data targets need to be derived then you can use field level routines. If the field are not available at Data source , but you want derive the value for a field during data load process , then you can use Start / End rouitne .

Hope it helps,

Cheers,

Balaji

[p_m8]

Hi Balaji,

Thanks for the note.

My question is actually more on the use of Transformation Group. The help file say:

================

The source contains three date characteristics:

● Order date

● Delivery date

● Invoice date

The target only contains one general date characteristic. Depending on the key figure, this is filled from the different date characteristics in the source.

Create three rule groups which, depending on the key figure, update the order date, delivery date, or invoice date to the target.

==================

With 2 Transformation Groups created manually, then what about the Standard Group? Does it mean system will do the mapping based on the two Groups created manually?

In above, can't we just create another date in Target also so that we can do one-to-one mapping directly? Better right.

I need your help to explain how it is done technically.

can you please help to explain the steps and screen too?

Kindly advise, thanks in advance.