BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

whats the difference between join and synchronization


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
bhuvandeep
Senior Member
Senior Member



Joined: 03 Jan 2008

Posts: 82


flag
PostPosted: Mon Jun 01, 2009 10:38 am 
Post subject: whats the difference between join and synchronization

hi
i wanted to know the difference between join and synchronization when using multiple context in my webi report
i wanted to know the use of both of them
it would be better if explained with example

_________________
thanks in advance
bhuvan
------------------------------
let there be light
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11475
Location: Manchester, UK


flag
PostPosted: Mon Jun 01, 2009 10:44 am 
Post subject: Re: whats the difference between join and synchronization

Have a look at the Reporter FAQ.

It's basically when two contexts are involved in queries. Joins occur when direct object matches are available, synchronisation when there aren't enough objects in one context to correctly match the data in both queries.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
bhuvandeep
Senior Member
Senior Member



Joined: 03 Jan 2008

Posts: 82


flag
PostPosted: Wed Jun 03, 2009 8:14 am 
Post subject: Re: whats the difference between join and synchronization

but what will happen exactly in synchronization?
still a little confused ..

_________________
thanks in advance
bhuvan
------------------------------
let there be light
Back to top
Jansi
Forum Fanatic
Forum Fanatic



Joined: 12 May 2008
ASUG Icon
Posts: 6577


flag
PostPosted: Wed Jun 03, 2009 8:29 am 
Post subject: Re: whats the difference between join and synchronization

Then it is the time to go through Solving the Mystery of Data Provider Synchronization presentation. Does it help?
_________________
Search is your friend.
I can do all things through Christ who strengthens me. Philippians 4 : 13
God is your protective shade! Wanna read about Your protective shade?!
Back to top
bhuvandeep
Senior Member
Senior Member



Joined: 03 Jan 2008

Posts: 82


flag
PostPosted: Thu Jun 04, 2009 8:47 am 
Post subject: Re: whats the difference between join and synchronization

thanks jansi...
but the document u referred was about multiple data provider
i wanted to about join that happens when there r multiple context ..
hows that happening

_________________
thanks in advance
bhuvan
------------------------------
let there be light
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22143
Location: Dallas, Texas


flag
PostPosted: Thu Jun 04, 2009 8:56 am 
Post subject: Re: whats the difference between join and synchronization

It uses the same logic.

A synchronized query occurs when your selected dimension objects don't match across every SQL pass. The net result is that your measure objects will only be correct for all common dimensions.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
bhuvandeep
Senior Member
Senior Member



Joined: 03 Jan 2008

Posts: 82


flag
PostPosted: Thu Jun 04, 2009 9:14 am 
Post subject: Re: whats the difference between join and synchronization

Dave Rathbun wrote:
It uses the same logic.

A synchronized query occurs when your selected dimension objects don't match across every SQL pass. The net result is that your measure objects will only be correct for all common dimensions.


that means dave if there r only common objects then join will happen and when uncommon objects are there then synchronization will happen for multiple context queries .. but net result for measure objects will only be correct for all common dimensions

_________________
thanks in advance
bhuvan
------------------------------
let there be light
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22143
Location: Dallas, Texas


flag
PostPosted: Thu Jun 04, 2009 9:27 am 
Post subject: Re: whats the difference between join and synchronization

Isn't that what I just said? icon_lol.gif

Suppose you have dimensions A, B, C and measures M1 and M2. Dimension A, B, and C exist in context M1, but only A and B exist for context M2. The results for M2 cannot be shown with dimension C because they don't exist in the same context. On the other hand, you can use both measures M1 and M2 with dimensions A and B because they're shared.

If you use M2 with C you will see the values for A and B repeated for each value of C.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
bhuvandeep
Senior Member
Senior Member



Joined: 03 Jan 2008

Posts: 82


flag
PostPosted: Thu Jun 04, 2009 9:35 am 
Post subject: Re: whats the difference between join and synchronization

thanks .. finally i understood that concept ...
_________________
thanks in advance
bhuvan
------------------------------
let there be light
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0415 seconds using 17 queries. (SQL 0.0122 Parse 0.0009 Other 0.0283)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo