Difference between Synchronization and join

building semantic layer
1

Hi All,

What is the difference between Synchronization and join in SQL generated in Webi?

ajq

anushajq (BOB member since 2005-02-22)

2

Are you asking the difference between two tables joined in SQL versus two queries linked together through a synchronization?

Two queries that are synchronized allow data to be joined (even outer joined) across databases.

digpen :us: (BOB member since 2002-08-15)

3

First, multiple SQL statements are generated when your data provider crosses multiple universe contexts (typically universe contexts are used to resolve fan/chasm traps).

Two SQL statementes are joined (not the same as SQL join!), when both SQL statments use the exact same dimension and detail objects, meaning both microcubes can be merged into ONE microcube.

Two SQL statements are synchronized, if one SQL statement contains dimensions or detail objects which do not exist in the other, therefore one gets two microcubes of different granularity.

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