Client says that report is taking long time to run? May 26, 2015 6:30 PM (in response to JC H) Currently Being Moderated Hi,I found the following link by Michael very helpful. But we will not be able to use both emp name and cust name in same block as these are not merged. Check if the multiple queries for each measure are checked. Trying disabling this and see if it makes a difference. my review here
But you can use any non-synchronized objects from any query to build a measure that will be displayed in the table... Alert Moderator Like (1) Re: Datasync error in Webi Simone Caneparo Nov 12, 2012 10:13 PM (in response to Mark Singley) Currently Being Moderated this could be dangerous if there is Enterprise,LDAP,Standalone,Windows AD and Windows NT ? 1 Answers Tell me the difference between cmc and cms? 4 Answers Wipro, For more Business Objects Interview Questions Click Here 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-
You can not post a blank message. Thanks for the effort !!ReplyDeleteramesh16 March 2014 at 12:25how to trouble shoot if i have a oracle data source and my report everything is correct but my user is not getting I replace Accounts1 (Hierarchy from Q1) by Accounts2 (Hierarchy from Q2)So, I've got the following table:X Axis: Date1 (Hierarchy from Q1), Month (Merged dim)Y Axis: Accounts2 (Hierarchy from Q1), Account (Merged Login Register Follow SCNJive Software Version: 126.96.36.199 , revision: 201308121150.54f5b14.release_5_0_6_2 : Hi, GuestLog OnJoin UsSearch for: HomeActivity0CommunicationsActions0BrowseMoreContentPeoplePlacesRecent Bookmarks Please enter a title.
Hit the Merge dymensions button and complete the merging. Display any measures coming from any query; 3. 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) . #context Error In Webi Now I will check the option"Extended Merge Dimension" from document properties.
Is there a tutorial that can describe this method in detail? To make query Synchronization work with a table: In the table: 1. Alert Moderator Like (0) Re: #DATASYNC error while merging two different quires anil . You need to ha...
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 Errors In Webi Reports Only display dimensions (one or more...) that are synchronized through all queries participating in the table; 2. if you are merging 2 queries , you can pull all objects of 1st query , but only one dimension object from 2nd query. Then use this detail object in the report and this should resolve your DataSync issue.
But if I involve any one non-merged dimension in this block, the results will start showing dimension values pertaining to that query only. The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension. #datasync Error In Web Intelligence and also you have noticed when you bring in ID, Name, Amount1, Service_Date,Service_Code from query1 and Amount2 from query2 in one block it works fine but when I tried to add Web Intelligence #datasync I Merged on company code-Key from both the quires.
Give that a try. Is This Answer Correct ? 39 Yes 12 No Answer / amit rathi #DATASYNC :#DATASYNC occurs when you place a dimension from a different dataprovider in a block containing dimensions But remember the rules..._________________Marc Remember the suffering of past generations - Think on the challenges of the next - Pass altruism along. Display any measures coming from any query; 3. Sap Business Objects #datasync
Query 1 Query 2 Now if you try to use all these objects in same block , you will get data sync error.(As webi will not be able to find any select table go to property click the option > show rows with empty measure values. 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 http://onlinetvsoftware.net/error-in/datasync-error-in-business-objects-report.php 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
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 Merging Dimensions In Business Objects This should remove the #DATASYNC error. 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
I just added this detail object before the first object in the table it works fine. 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, 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 Extend Merged Dimension Values How can I achieve this.
Now it will work as full outer join as shown in screenshot: So this option makes the query to give full outer join result set even if you have selected specific Mandatory condition to merge objects is to have same data type. 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 YEAR(MERGED)MONTH(MERGED)DATE(MERGED)ACTUALPLANACCOUNTS Best Buy(Account) Apple(Account) Western Digital Can we not merge the Accounts 1 & 2 ?Thank You Alert Moderator Like (0) Re: Datasync error in Webi Abhishek Mangipudy
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, Example: Dimensions from different data providers in a block If a report based on the Island Resorts Marketing universe contains data providers with the objects (Year, Revenue) and (Quarter), a block 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 ? 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 ...
There is also one option which makes the functionality of left or right outer join to work as full outer join. I'm not 100% this will work on a hierarchy- but that's how you get around the datasync error and take objects from both queries that are merged together. Back to top mukul.jainSenior MemberJoined: 25 Oct 2005Posts: 51 Posted: Thu May 08, 2008 9:23 pmPost subject: Re: Merge Dimensions - #DATASYNC Hi .. I merge the dimensions: year1 to year2, acc1 to acc2, month1 to month2.
Thought it was an intersection the whole time!ReplyDeleteAnonymous26 October 2013 at 08:46if You are are getting same result after using merge dimension and extended merge dimension, then whats use of extended 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 After checking the Avoid Duplicate row aggregation, I always ends up with the "Unable to get the first page of current report. Back to top dip_anjSenior MemberJoined: 26 Feb 2007Posts: 68 Posted: Mon May 12, 2008 6:51 amPost subject: Re: Merge Dimensions - #DATASYNC As Marc pointed out in WEBI it is not
It just have to be Summarizable... 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 If you use cust name in the above block it wont work as full outer join. Login Register Follow SCNJive Software Version: 188.8.131.52 , 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|