Powered by Blogger. 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| But if I involve any one non-merged dimension in this block, the results will start showing dimension values pertaining to that query only. But remember the rules..._________________Marc Remember the suffering of past generations - Think on the challenges of the next - Pass altruism along. http://sovidi.com/error-in/datasync-error-web-intelligence.php
You can add dimension objects from both data providers, but onle in DeskI not in webi Thanks Mukul Back to top Marc DoucetPrincipal MemberJoined: 11 Jul 2007Posts: 360Location: Montreal, Quebec, Canada Please suggest me the best practice to follow , while working on multiple bex quires . Where u need to check? 2 Answers Wipro, what is report tracing in bo 5 Answers TCS, Satyam, how to increase the perfomance in ur designer & reporting? Basically we merge objects from two or more queries in one webi report, so that we can use them in same block.
#datasync Error In Web Intelligence
How to Bring "Others" in a Pie chart when ranking is applied in the data. Alert Moderator Like (0) Re: Datasync error in Webi Mark Singley Nov 8, 2012 10:04 PM (in response to Alexey Veselov) Currently Being Moderated You'll get a datasync error if you Mandatory condition to merge objects is to have same data type. Merge Id is showing all rows coming from emp id and cust id and their corresponding revenue and salary column values.
Question Posted / sunnyodc 2 Answers 30611 Views IBM, TCS, I also Faced E-Mail Answers Answers were Sorted based on User's Feedback Answer / sunnyodc This error come when 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 But you can use any non-synchronized objects from any query to build a measure that will be displayed in the table… It just has to be Summarizable… Anything that is not #context Error In Webi Category: Tips and Tricks Post navigation ← BO Lead ETL TESTER → Leave a Reply Cancel reply Your email address will not be published.
Tweet Datasync error in Webi Alexey Veselov Oct 11, 2012 1:31 PM Currently Being Moderated Hello!Could you please help with such a problem:I have 2 Bex data sources:Query 1Query 2Hierarchies:- Date1- Datasync Error In Business Objects This is now showing results as Full outer join. 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 great job!ReplyDeleteAnonymous23 March 2013 at 02:08Thanks a lot....ReplyDeleteAnonymous2 April 2013 at 04:11liked the way it was explained..
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. Errors In Webi Reports The Chasm trap occurs when ... Try creating a variable for Date, but make it a detail, and another for Number, and make it a detail, and see if you can add them to the block._________________Michael Welter, Alert Moderator Like (0) Re: #DATASYNC error while merging two different quires anil .
Datasync Error In Business Objects
Display any measures coming from any query; 3. now bring them on report. #datasync Error In Web Intelligence I merge the dimensions: year1 to year2, acc1 to acc2, month1 to month2. Web Intelligence #datasync 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 ?
How can I achieve this. I've tried using each of the ID dimensions (the merged and from both queries) to the same end. More discussions in SAP BusinessObjects Web IntelligenceWhere is this place located?All Places SAP BusinessObjects Web Intelligence 8 Replies Latest reply: May 26, 2015 6:30 PM by Dee J. Check the SQL tab in Parameters under Multiple Paths. Sap Business Objects #datasync
Display any measures coming from any query; 3. For eg. But funny thing is when I dropped this detail object at the end of the table means just after the last object in the table it gives data and at some http://sovidi.com/error-in/datasync-error-in-business-objects-report.php Thanx Back to top S.chandbForum MemberJoined: 11 Jul 2007Posts: 5Location: Pune Posted: Wed May 07, 2008 12:17 amPost subject: Re: Merge Dimensions - #DATASYNC you have two simple queries from the
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 Merging Dimensions In Business Objects Please type your message and try again. Alert Moderator Like (0) Re: Datasync error in Webi Dee J.
Posted by GS at 17:43 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: business objects, extended merge dimension, merge dimension, web intelligence 17 comments: Garima Saxena8 August 2012 at 21:32Good
Think of it as a warning rather than an error. Hope it clarifies - Good luck_________________Marc Remember the suffering of past generations - Think on the challenges of the next - Pass altruism along. Made query 1 as the primary query (a,b,c) and created the details objects (x,y,z) for dimensions from query 2.The brought in the merged Company code to report and fields directly from Extend Merged Dimension Values now I got the clarity of Merge Dimensions..Pretty explanation.Keep poting more...ReplyDeleteAnonymous5 March 2013 at 15:14Crystal clear!!
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 can you pls let us know How do u link different data providers in a single report ??ReplyDeleteAnonymous14 January 2013 at 12:28Thanks....a lot... Advanced Join Property Advance join property in universe is present , when you click a join between any two tables and click on Advance button. 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
Now I will check the option"Extended Merge Dimension" from document properties. Suggestions Highly appreciated.ThanksAnil 2978Views Re: #DATASYNC error while merging two different quires Bala Manoj Kumar Gade Jun 8, 2014 3:43 PM (in response to anil .) Currently Being Moderated You have Only display dimensions (one or more…) that are synchronized through all queries participating in the table; 2. This should remove the #DATASYNC error.
Thanks, Mike Back to top MichaelWelterForum AficionadoJoined: 08 Aug 2002*6Posts: 14868Location: Rancho Cucamonga, CA, USA, Earth, Milky Way Posted: Fri Jan 19, 2007 1:13 pmPost subject: Re: Merge Dimensions - #DATASYNC Jun 6, 2014 11:50 PM Currently Being Moderated Hi All, I am on SAP BO 4.1 SP2 Patch2 , I am trying to build a webi report on top of 2 Aggregate Awareness in Universe Lets see what is this aggregate awareness functionality and how it is useful in universe.