Cube to Cube transformation

[Former Member]

Dear Experts,

I need to build a transfert between tow cubes within rule Goup and DTP.

In our case the transformation seems more complexe, here our example :

Source cube :

Version; FiscalYear; KeyFigure1; KeyFigure2; KeyFigure3;

1; 2009; 111; 222; 333;

2; 2010; 444; 555; 666;

Target cube :

Version; FiscalYear; KeyType; Amount;

1; 2009; KeyFigure1; 111;

1; 2009; KeyFigure2; 222;

1; 2009; KeyFigure3; 333;

2; 2010; KeyFigure1; 444;

2; 2010; KeyFigure2; 555;

2; 2010; KeyFigure3; 666;

My question is how to use the group rules to get the technical names of key figures 1, 2 & 3 into the target cube.

Thx for your help

Soufiane

Edited by: Soufiane FARRAH on May 16, 2011 5:51 PM

[Former Member · Accepted solution]

hi,

there is no way that a rule group will pick up key figure definition in the rule group.

your requirement is to split a single record into multiple records based on KF.

for example:

Cube 1:

char1 year MTD QTD YTD

XYZ 2009 111 222 333

you need the result in the next cube to be

char1 year kftype value

XYZ 2009 MTD 111

XYZ 2009 QTD 222

XYZ 2009 YTD 333

you can achieve this by using expert routine. In expert routine

loop at the package

assign char1

assign year

kftype = MTD

value = KF for MTD

Append to result

kftype = QTD

value = KF for QTD

Append to result

kftype = YTD

value = KF for YTD

Append to result

End loop.

This routine will split the one record into 3. the KF types have to be defined/hardcoded.

hope this helps,

Arvind.

[Former Member · Accepted solution]

Thank you Arvind Tekra,

I will try the routine.

Best regards

Soufiane

[Former Member]

you need to have 3 rule groups say RG1, RG2, RG3.

In RG1, you have to map keyfigure1 to the amount field and for Keytype field, select constant in rule type and enter the techinical name of Keyfigure1.

Similarly in RG2, you have to map Keyfigure2 to the amount field and for Keytype field, select constant in rule type and enter the techincal name of Keyfigure2.

follow the same process for RG3 using Keyfigure3.

For version and year, it should be direct mapping in all the three rule groups.

--- Thanks...

[mr_v]

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d085fa63-f54c-2c10-b5ba-cc4ac2315...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90754b76-bcf1-2a10-3ba7-b299b2be0...