Synchronization in query

building semantic layer
1

Hi,
My report query is generating “Synchronization”(select1, select2). So basically i have 4 tables in the universe as laid out below. table C is a derived table which has a sub query (select * from(select Col1 from D where Col1=‘ex’). The report is using objects from table A and C. My question is there are no measures in this report but as a good universe design should the query return ‘Synchronization’ and what can i do to resolve it?

A(1-M)B(1-M)C

D (stand alone table)

showt2 (BOB member since 2009-05-11)

2

Hi,

Do you have contexts in your Universe?

Generally when you are hitting the tables that are in different contexts, WebI creates multiple queries.

izak004 :us: (BOB member since 2010-11-10)

3

As your table D is isolated you will always have a synchronization when using Table D with any other table.

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