DTP Vs Update Rules Error!!!!!!!!!!!!!!!!!!!!!!1

[Former Member]

Hi guys,

I have a scenerio , where I need to have data from 2 DSOs in to one combined DSO. Lets Says the 2 DSOs as DSO A and DSO B. and the Third as DSO C.

I want to get DSO C Structure as exactly as DSO A. and DSO B structure is only few fiew fields from DSO A (Key Fields are same). I have loaded the data in to DSO A and DSO B using Transformation and DTP . Now How to load DSO C data I mean combined data of DSO A and B.

1.If I create update Rules to DSO C using DSO A and DSO B. Iam not getting any data in to DSO C. (Do I need to make any settings in DSOs to update the data of A and B in to C ?).

2.If I create 2 transformations between DSO A -C and DSO B-C. I am sure I need to create DTPs to get the corresponding data. When I do that Iam getting 2 separate sets of data for DSO C. But I need data as one set from DSO A & B in to C.

Please help me ASAP and let me know if you need more information on it.

Thanks in advance

[Former Member · Accepted solution]

Harish,

if you want populate the extra fields from DSO B(non key fields) to DSO C (assume those fields not available in DSO A). then create a sepecrate transformations. Set aggregation type to Over Write(as you did in 3.X for only those fields which comming from DSO B).

If DSO Fields coming from DSO A as well... it's better to look up in the start routine of DSO A to DSO C for DSO B Values .

<b>you will get 2 set of records, if your Key fields in DSO A, DSO B and DSO C different.</b>

all the best.

Regards,

Nagesh Ganisetti.

[Former Member · Accepted solution]

Thank you Nagesh...I got it. I need to create a start routiene , as I dont have any extra fields in my DSO B. Can you please give me an idea or let me know where to find this start routiene code to do this...

thanks

[Former Member · Accepted solution]

What If I have 2 dirrent DOS data and if I create 2 Transformations ? How can I see the Combined Data ....?Please let me know...

thanks

[Former Member · Accepted solution]

Harish,

as i told you earlier, if the fields you are looking from DSO B is not available in DSO A, you can create transformation usign respective DSO if your Key fields are same in both DSO A and DSO B..

assume...F1, F2, F3 are key fields in both DSO A and B.

DSO A:

F1, F2, F3, F4, F5, F6, F7.

DSO B:

F1, F2, F3, F8, F9.

DSO C:

F1, F2, F3, F4, F5, F6, F7, F8, F9.

If you load data from DSO A to DSO C, it will create one record in DSO C with updation of F1, F2, F3, F4, F5, F6, F7(because f1, f2, f3, f4, f5, f6, f7 only mapped).

If you load data from DSO B to DSO C, it will <b>Update</b> existing entry using Key fields for other 2 fields(which mapped from DSO B to DSO C).

Change log table of DSO C update with 2 records(i'm talking about Standard table).

write optimized works differently.

all the best.

Regards,

Nagesh Ganisetti.

• assign points if it helps.

[Former Member · Accepted solution]

Hi Nagesh..Thanks for your time...Iam doing exactly what you are saying...

But when I create transformation from A-C / B-C ...am getting errors...i.e,

i am mapping the fields which i need rest of them I am not mapping. Fields for which i am not mapping leads to errors like

Internal error: Invalid Aggregation Info No entry for InfoObject: ZFINAL_DT - contact SAP. But I dont need this Object in that transformation at all..Iam keep getting the same error untill its mapped to some field from Source DSO or delete from the Base DSO C....

Please help...Iam sure there should be a way to avoid this...you have any idea on this...? recently patches changed from sp9 to 10...may be that might be the problem i guess...

I wil wait for ur answer...rest every thing is fine ...

thanks

[Former Member · Accepted solution]

Harish,

not a problem. check which feilds you don't want to map. Make those as <b>"No Transformation"</b> in Rule details.

Note: What ever is possible in 3.X for UR or TR, everything is possible in Transformation of BI 7.0 As well( excpet return table, etc).

all the best.

Regards,

Nagesh Ganisetti.

[Former Member · Accepted solution]

Hi Nagesh,

Thanks , All the fields that i didnt map was by default no transformation , except some fields which has transformation as initial. I have deleted one field from the DSO C and activated both DSO and Transformation. Now am getting the same error for the next field that i didnt map...Any help. ? I am assigning the points as I have already got many answers for this question...& I will wait for ur reply.

thanks

[Former Member · Accepted solution]

Harish,

If you are sure of all the fields which not requied set to " No Transformation". Please delete the Transformation and Recreate it.

Even i got error like that. I deleted the transformations and Recreated.

All the best.

Regards,

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member · Accepted solution]

Ok Nagesh Iam trying it now. But while activating the transformation its shwoing the following error

Formula 44R3GTMTGDMHDXLSEE9LOVR2D is not available in the table RSAFORMMAP.

I have a formula in my transformation to find out the final due date and its syntactically correct. And I was able to activate it before.Do you have any idea on this....

[Former Member · Accepted solution]

I got it Nagesh...I just deleted the transformation and created fresh transformation with all the routienes and forumals ..then it worked well... Now again I have only 2 fields are different in DSO B than DSO A (those fields must be populated using routiens. So is this possible with start routiene ? ) I mean how to writhe the code to call DSO B in Start routiene of the transformation DSO A-C..Please send me the brief code...

thanks for the help again

[Former Member · Accepted solution]

Harish,

there are some issues with DTP and Transformation (Deletetion of DTP's and Transformation) .

Check whether Formula ID available in RSAFORMMAP? if not created formula again in the Tranformations.

Cretae Customer Message.

Regards,

Nagesh Ganisetti.

• assign points if it helps.

[Former Member · Accepted solution]

Did you get a chance to look into this...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/e73bfc19-0e01-0010-23bc-ef0...

it is mainly for End Routine. Start Routine and End routine both are much similar.

all the best.

Regards,

Nagesh Ganisetti.

• assign points if it helps.

[Former Member · Accepted solution]

thanks got it....points assigned..i will get back to if I have any complicated issues in my development...