#DataSync Error

[Former Member]

Helloo Guys,

I am working on report which have to fetch the data from two data providers Bex Query and Excel.

1) In bex query I have taken some feilds for example : VPU-Key, Region-Key ..................................... which are all detail objects and also some measures. I have ran the report and got the data.

2) I have taken data from excel which have columns like VPU-Key(Dimension) and some other dimension columns.

I have merged the VPU-Key from Bex query and VPU-Key from Excel data. When I tried to add the other columns from th4e Bex query it is showing an error like #DataSync error.

Can you please help out for any solutions.

Final output should be

VPU-Key  and all the other objects from Bex and Excel

Regards,

Eswar

[Former Member · Accepted solution]

Hello,

you have to merge also "all other" dimensions, not only the key. Refer here for more information on merging:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_ia_en.pdf#page=247

BR

[Former Member]

Hi,

Try to create a detail variable associated with the merged dimension.

[Former Member]

I have created the detailed variable and tried to add in to the report, ithad displayed the data for the first query not merged one.

[former_member184594]

Victor is right. You should check if you have more detail dimension in your table other than your merged one. If you have more detailed dimension in your table, it tries to break in more details and since your merged dimension is not detailed does not know the relation and throwing you #DataSync error.

[former_member580328]

Hi,

Check the following link for information on #DataSync Error

http://ghuglu.com/?p=254

Regards,

Mahendran N