Datasync error in Webi

[Former Member]

Hello!

Could you please help with such a problem:

I have 2 Bex data sources:

Query 1	Query 2
Hierarchies: - Date1 - Accounts1 Dimensions: - Year1 - Month1 - Account1 Measure: - Actual	Hierarchies: - Date2 - Accounts2 Dimensions: - Year2 - Month2 - Account2 Measure: - Plan

I want to merge both queries in one report.

Step 1. I merge the dimensions: year1 to year2, acc1 to acc2, month1 to month2. So I've got 3 merged dims: Year, Month, Account

Step 2. I generate the table

X Axis: Date1 (Hierarchy from Q1), Month (Merged dim)

Y Axis: Accounts1 (Hierarchy from Q1), Account (Merged dim)

Body: Actual, Plan

And everything is OK.

Step 3. I replace Accounts1 (Hierarchy from Q1) by Accounts2 (Hierarchy from Q2)

So, I've got the following table:

X Axis: Date1 (Hierarchy from Q1), Month (Merged dim)

Y Axis: Accounts2 (Hierarchy from Q1), Account (Merged dim)

Body: Actual, Plan

Then there is an error #DATASYNC error in all the parts of the table

(Picture attached)

Thank you!

[Former Member]

You'll get a datasync error if you try to use an object from each query.

The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension.  I'm not 100% this will work on a hierarchy- but that's how you get around the datasync error and take objects from both queries that are merged together.  Give that a try.

[former_member188911]

this could be dangerous if there is no logical relationship between detail and dimension, at some point you could get incorrect results

on a hierarchy the risks are much higher...

[Former Member]

Hi,

In order to resolve errors #datasync, #context while trying to Merge two or more data providers, Create detail object for Actual Measure and Plan Measure objects and make associate dimensions as Account1 for this two details dimensions and then

Pull all the objects(only merged dimensions and Detail objects) into Report Pane....Hope you will see all the objects in the report from two data providers...

Let me know if you still have any queries...

[Former Member]

I've seen the concept of creating a detail object discussed over and over again. Is there a tutorial that can describe this method in detail?

[Former Member]

Hi,

I found the following link by Michael very helpful.

https://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/

Hope this helps..

Regards,

[Former Member]

What you want to do is create a Detail object for Account2 and Date2 and and use the associated dimension as the Account (merged). Then use this detail object in the report and this should resolve your DataSync issue.

[Former Member]

Hi Gurus,

Will this option work ?

	YEAR(MERGED)
	MONTH(MERGED)
	DATE(MERGED)
	ACTUAL	PLAN
ACCOUNTS
Best Buy(Account)
Apple(Account)
Western Digital

Can we not merge the Accounts 1 & 2 ?

Thank You

[former_member188911]

you get the #DATASYNC message because the engine is unable to synchronize the two dataproviders. it is not sufficient to declare the merged dimensions and hierarchies are more complex than it seems so you are using a non supported workflow.