Hi Rao,
Please find the reasons below.
#context - Occurs in measure values if you try to include objects from different context(Universe) which are not linked.
Sol:- Use calculation context in the variable on merged dimension.
eg:- Sum([Sales Qty] forall ([DATE])) ([DATE] - Merged dimension on both queries)
#Incompatible - Occurs in dimension values if you try to include objects from different context(Universe) which are not linked.
Sol:- creat a detailed variable for the incompatible dimension object and associating it with the merged dimension
#Data Sync - Occurs when you place a dimension from other data provider along woth the dimensions in same data provider.
Sol:- Merge 2 data providers on common dimension.
If you want to see the other dimensions(in DP2) apart from the common dimension in the report with the dimensions(In DP1), convert the other dimension object which is not merged to Detail object and use that object.
Please provide further inputs.
Thanks and Regards,
Tharini
Add a comment