Transformation Start Routine question
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.