Transformation Start Routine question

[Former Member]

Hi Experts,

In the DSO I have the line items for the Change Numbers, along with the Object Category and the Object:

CN1, 41, OBJ1

CN1, 41, OBJ2

CN1, 02, OBJ3

CN1, 31, OBJ4

CN1, 31, OBJ5

CN1, 31, OBJ6

In the InfoCube it will be required to have just a single record for this using the Change Number and the respective Objects will be split by Category into Key-Figures as counters:

Change Number, KF41, KF02, KF31

CN1 , 2 , 1 , 3

Is is possible to do this is the Transformation Start Routine?

If it is possible, how can I do it?

Thanks a lot for your help.

Renato

[Former Member]

Yes. It is possible. In the cube you just keep change number & KFs KF41, KF02, KF31....

In the transformation you can update KFs depending on Category.

e.g.for KF41 field routine can be ---

if category = 41.

result = 1.

endif.