I am getting #DATASYNC error . 1.How to over come the # DATASYNC Error and what should be passed in for associated Dimension while creating the details for (x,y,z) . Check the SQL tab in Parameters under Multiple Paths. Fan Trap Fan Trap in Business Objects This is also a join path problem created in universe when below scenarios are met: Consider table A, B ... Back to top Marc DoucetPrincipal MemberJoined: 11 Jul 2007Posts: 360Location: Montreal, Quebec, Canada Posted: Fri May 09, 2008 3:41 pmPost subject: Re: Merge Dimensions - #DATASYNC I wae talking in Webi http://gatoisland.com/error-in/datasync-error-web-intelligence.php
You can not post a blank message. Please help I have two simple queries from the same universe in a WEBI report: Query 1 = ID, Name, Amount1, Service_Date,Service_Code Query 2 = ID, Amount2,Posting_Date If I understand correctly, Advanced Join Property Advance join property in universe is present , when you click a join between any two tables and click on Advance button. Back to top BaazigarPrincipal MemberJoined: 10 Jun 2004Posts: 420Location: New York Posted: Thu May 08, 2008 6:55 amPost subject: Re: Merge Dimensions - #DATASYNC In my case I am merging on
Note: this option wont work if you use non-merged dimension in the block. So basically it is working as Left or Right Outer join when we try to use any dimension in the block which is not merged. Login Register Follow SCNJive Software Version: 220.127.116.11 , revision: 201308121150.54f5b14.release_5_0_6_2 Not endorsed by or affiliated with SAP Register| Login Want to sponsor BOB? (Opens a new window) Index|About Sponsors| After checking the Avoid Duplicate row aggregation, I always ends up with the "Unable to get the first page of current report.
ghuglu.com In search of talents all around Skip to content HomeAboutResume UploadView Uploaded Resumes BO Query Synchronization By kz | January 3, 2013 0 Comment Q: What is Synchronized Query in Do we have to apply any patch for this? Chasm Trap Chasm Trap in Business Objects : This is a join path problem that is created in a Universe. #context Error In Webi : Hi, GuestLog OnJoin UsSearch for: HomeActivity0CommunicationsActions0BrowseMoreContentPeoplePlacesRecent Bookmarks Please enter a title.
You can not post a blank message. Datasync Error In Business Objects Then use this detail object in the report and this should resolve your DataSync issue. This should remove the #DATASYNC error. Check if the multiple queries for each measure are checked. Trying disabling this and see if it makes a difference.
One more interesting point that I have noticed is when I bring in ID, Name, Amount1, Service_Date,Service_Code from query1 and Amount2 from query2 in one block it works fine but when Errors In Webi Reports Powered by Blogger. So I've got 3 merged dims: Year, Month, AccountStep 2. Similarly if you don't use merge id column and use emp id or cust id along with revenue and salary, that will work as Left or Right outer join and not
I've tried using each of the ID dimensions (the merged and from both queries) to the same end. So you'll get error. Try with dimensions with same data type. In order for you to get a Join instead of Synchronization, you need to have all the same dimensions available to #datasync Error In Web Intelligence We will get data sync error if we try to use them in same block. Web Intelligence #datasync Display any measures coming from any query; 3.
How to Bring "Others" in a Pie chart when ranking is applied in the data. Company Code Key as the associate dimension.You can drag all the detail objects along with the merged dimension and measures. The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension. Only display dimensions (one or more…) that are synchronized through all queries participating in the table; 2. Sap Business Objects #datasync
Back to top mukul.jainSenior MemberJoined: 25 Oct 2005Posts: 51 Posted: Thu May 08, 2008 9:23 pmPost subject: Re: Merge Dimensions - #DATASYNC Hi .. that means put them in new variable and define that variable as measure. Need detailed answer please 1 Answers HCL, What is pragma? 1 Answers Once the project is submited to the Client. navigate to this website So what BO does is run the query for each synchronization and then automatically merges the result before displaying the data. if you are using contexts in the universe and that
If 2 dimensions with different names but same data type we can comfortably merge them. in following case the reason for getting #DATASYNC is Query 1 = ID, Number Query 2 = ID, Date hare Merging Dimensions In Business Objects Back to top BaazigarPrincipal MemberJoined: 10 Jun 2004Posts: 420Location: New York Posted: Tue May 06, 2008 1:14 pmPost subject: Re: Merge Dimensions - #DATASYNC I too face the same issue and Alert Moderator Like (0) Re: Datasync error in Webi JC H Sep 9, 2014 5:22 PM (in response to Chandrababu Naidu) Currently Being Moderated I've seen the concept of creating a
Thanks Saichand Back to top dip_anjSenior MemberJoined: 26 Feb 2007Posts: 68 Posted: Thu May 08, 2008 2:13 amPost subject: Re: Merge Dimensions - #DATASYNC Try this and let me know if Alert Moderator Like (0) Re: Datasync error in Webi Leela Padmanabhuni Nov 12, 2012 10:52 PM (in response to Alexey Veselov) Currently Being Moderated Hi Gurus,Will this option work ? Login Register Follow SCNJive Software Version: 18.104.22.168 , revision: 201308121150.54f5b14.release_5_0_6_2 : Hi, GuestLog OnJoin UsSearch for: HomeActivity0CommunicationsActions0BrowseMoreContentPeoplePlacesRecent Bookmarks Please enter a title. Extend Merged Dimension Values When I used cust id revenue and salary, the block look like this: So its showing data as left outer join .
Think of it as a warning rather than an error. in above case the reason for getting #DATASYNC is Query 1 = ID, Number Query 2 = ID, Date hare first one is number datatype,date is other datatype.so,i think this is How can I achieve this. Alert Moderator Like (0) Re: Datasync error in Webi Chandrababu Naidu Apr 11, 2014 2:24 PM (in response to Alexey Veselov) Currently Being Moderated Hi,In order to resolve errors #datasync, #context
Is it the best practice to show the duplicate row aggregation (or) we need to always uncheck the option . All Rights Reserved. Is there a tutorial that can describe this method in detail? Only display dimensions (one or more...) that are synchronized through all queries participating in the table; 2.
Then add these newly created detail/attribute objects to the table block that is having initial query objects with merged dimension, with this you see result set of query_two in the table May 26, 2015 6:30 PM (in response to JC H) Currently Being Moderated Hi,I found the following link by Michael very helpful. Category: Tips and Tricks Post navigation ← BO Lead ETL TESTER → Leave a Reply Cancel reply Your email address will not be published.