Details losing their link on refresh

[Former Member]

I have a report which has been generated from 3 queries with dimension merged across all 3.

I have then created some detail variables so that data can be included on the report that only exists in one of the queries. that works fine and I have saved the report.

Now comes the problem, when I open the report and refresh I get #DATASYNC errors across the entire report.

If I remerge the dimensions, the details lose their links but when I add the links back, the #DATASYNC errors disappear and my report returns.

Obviously this is not ideal.

Has anyone else seen this problem or has any ideas on how to fix it.

I am running BOXI rel 3.1 SP2

[Former Member]

Hi Sue,

The #DATASYNC error appear, if you try to add a dimension from one query to a block (for example, a table or chart) that contains objects from a different query. Try using the 'ForceMerge()' function on those objects, and check if the data appears.

Good Luck.