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