Data Synchronization Error in Webi Reports

building reports webintelligence
1

Hi,

Could anyone explain what is data synchronization error and why do we get with an example. I would really appreciate if anyone can explain me.

Thanks in advance :slight_smile:

IndraniS (BOB member since 2012-04-19)

2

Hi ,

Normally datasync error comes when you have merged two or more data provider and one of them is not refreshed properly .

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

3

More specifically, when we choose objects from two different fact tables and they’re in different contexts, synchronization occurs.

mk19 :bangladesh: (BOB member since 2009-07-20)

4

That’s different. The OP is after an understanding what the #DATASYNC error means in Webi.

#DATASYNC errors occur when you are working with multiple providers and you try to use unrelated objects from different queries. If you have Car Make and Sales Amount from one query and Year from another and try to build all three in a block, you will get a #DATASYNC error because the Car Make and Year objects are not related. You will also encounter a #CONTEXT error for Sales Amount (because it’s a measure).

5

This error come when you fetch more than 1 dimensions from
2 joined queries.

if you are merging 2 queries , you can pull all objects of
1st query , but only one dimension object from 2nd query.
you can use merged object from 2nd query but not the other
ones,
if you want to show remaining objects of 2nd query make a
measure variable of each dimension. that means put them in
new variable and define that variable as measure.
now bring them on report. select table go to property click
the option > show rows with empty measure values.

Luke

Rango90 (BOB member since 2012-11-13)

6

The caveat with that is that each of those objects that you make a detail must have a one-to-one relationship with the merged dimension.

7

I have a similar kind of issue.

I have three tables in the database

B—A---C
N—1---N

joins are A left outer join B
A equi join C

two seperate contexts were defined in this case(A-B and A-C)…common object in both contexts is ID

For the report am trying to build i have to use objects from both B and C but I can’t seem to be able to do that. I am getting datasync errors and also when I try to define the dimension object…it still doesn’t work.

Please help me with this…
Thanks in advance

avbo (BOB member since 2012-03-16)

8

How do the objects from B relate to the objects from C?

If they have no natural relationship beyond both “belonging” to A, then they cannot sensibly go together.

This may either be because they simply don’t belong together or the data model needs improving.

9

Thanks for the reply mark.

I was able to get create detail objects for both dimensions am using and get them together(using context operator: IN) into a single table. But the only problem is
Dim(table B): since its defined as a left outer join i was able to get all the values of dim(table B) for a given id number from table A
Dim(table C):since this is a equi join I am getting multivalue error in rows where dim(table A) has multiple values in dim(table C).

I am assuming its because of the joins between the tables…but i am not an expert…i just started using BO

I am trying to do conditions/calculations(counts) on the ids available in table A with objects available in table B and table C.
A is primary info table
B is the degree table
C is the donations table
I am trying to get people who made donations in a particular year but have a degree prior to that year.

I am sorry if am not clear…But would definitely try to explain a bit more in detail if necessary.

Thanks

avbo (BOB member since 2012-03-16)

10

OK, you’ve misunderstood details. Details must have a one to one relationship with their dimension - a Customer ID can have only one telephone number for example

You are better approaching this with a correlated subquery in your query panel -
Donation Year Equal To This Year
And
Degree Candidate In List (Degree Candidate Where Graduation Year Equal to Last Year)

11

For this report I have to show data for 5years(2012 through 2008)…so i have to do all the calculations in report level.

Is there any other approach for this?

-------------general question------------
You mentioned that detail object only works when there is 1:1 relationship.

But the object: dim(tableB), which is part of table(B) , has many values for one Id from table A and it works perfectly well when used as a detail variable: Can you please explain me why it only works with this object and not with the object from table©

Thanks for your time on this Mark.

avbo (BOB member since 2012-03-16)

12

this helped me, but i selected show empty dimensions value

Swimmer :netherlands: (BOB member since 2006-08-23)

13

Which in the real world is totally unrealistic, yes?! :wink:

Andreas :de: (BOB member since 2002-06-20)

14

Not at all. A customer would have one current mobile phone number, one current address, one current(!) gender, etc.

15

Usually handled in a DW by having a slowly changing customer dimension, manged by sequence, Max record date etc

Mak 1 :uk: (BOB member since 2005-01-06)