For eg. i.e. Which is the best practice ? 3. Thanks, Baazi Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to Post Forum Index -> Building Reports -> weblink
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 ? 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 Basically we merge objects from two or more queries in one webi report, so that we can use them in same block. Advanced Join Property Advance join property in universe is present , when you click a join between any two tables and click on Advance button.
However, when I try to create a block with those objects, #DATASYNC is displayed in every column. https://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/Hope this helps..Regards, Alert Moderator Like (1) Go to original post Tweet Actions Login to follow, like, comment, share and bookmark content. Display any measures coming from any query; 3. Only display dimensions (one or more...) that are synchronized through all queries participating in the table; 2.
so my final table looks like this v_POST_DT|FIRST_NAME|LAST_NAME|SALARY|v_POST_DT I don't want to have v_POST_DT at the begining and still it should work fine without #MULTI value message. This should remove the #DATASYNC error. 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- #context Error In Webi Please type your message and try again.
Back to top BaazigarPrincipal MemberJoined: 10 Jun 2004Posts: 420Location: New York Posted: Wed May 14, 2008 1:01 pmPost subject: Re: Merge Dimensions - #DATASYNC I deleted the earlier detail object for Datasync Error In Business Objects Hit the Merge dymensions button and complete the merging. Is it the best practice to show the duplicate row aggregation (or) we need to always uncheck the option . Translate Picture Window template.
The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension. Errors In Webi Reports i want to schedule 3 reports consicutively....how can i achieve this 4 Answers HCL, limitaions of cross tab ? 1 Answers what is fantrap? 2 Answers Can anybody Any thing that is not a number cannot be defind as a measure thus have to be synchronized. 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
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 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 Check if the multiple queries for each measure are checked. Trying disabling this and see if it makes a difference. Web Intelligence #datasync 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
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 May 26, 2015 6:30 PM (in response to JC H) Currently Being Moderated Hi,I found the following link by Michael very helpful. How can I achieve this. I've logged a case with BO, but thought I'd see if anyone else has run into the same thing. Sap Business Objects #datasync
If you use cust name in the above block it wont work as full outer join. Mandatory condition to merge objects is to have same data type. 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 check over here But remember the rules..._________________Marc Remember the suffering of past generations - Think on the challenges of the next - Pass altruism along.
Do we have to apply any patch for this? Merging Dimensions In Business Objects Thanks, Kon Back to top anair_boPrincipal MemberJoined: 05 Dec 2006Posts: 253Location: Philly, PA Posted: Fri Mar 14, 2008 3:59 pmPost subject: Re: Merge Dimensions - #DATASYNC Facing the same issue.Any resolutions Back to top mukul.jainSenior MemberJoined: 25 Oct 2005Posts: 51 Posted: Thu May 08, 2008 9:23 pmPost subject: Re: Merge Dimensions - #DATASYNC Hi ..
You can not post a blank message. Required fields are marked *Comment Name * Email * Website CAPTCHA Code * Upload your Resume Allowed Files:*.pdf - *.doc - *.docx - *.txt - *.rtf Categories Current Opportunities (18) Previously It is not recommended to check "Avoid Duplicate Row Aggregation".~ Manoj Alert Moderator Like (0) Go to original post Tweet Actions Login to follow, like, comment, share and bookmark content. Extend Merged Dimension Values Only display dimensions (one or more…) that are synchronized through all queries participating in the table; 2.
Jun 9, 2014 5:18 PM (in response to Charuta Sathe) Currently Being Moderated Hi Charuta Sathe ,I was able to remove the #Datasync , If I check the Avoid Duplicate Row This is because data in the other query is not able to sync with the initial result set, this is a know behavior.There are two workarounds:1) Merging all common dimension/characteristic objects: thae basic concept of synchronization is if you want to mrege the two dimensions they should have of same datatype.it is not madatory to be have same name.if 2 dimensions with 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 Let's say there is a set of Region and there Revenue like below: Region Revenue East Japan 1,012,727 Bav... datasync.JPG 32.3 K 20810Views Tagsnone (add) Tags: error, report, bex, bw, hierarchy, web_intelligence, webi Re: Datasync error in Webi Simone Caneparo Nov 8, 2012 3:47 PM (in response to Alexey Veselov) ID is that dimension.
Then use this detail object in the report and this should resolve your DataSync issue. 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, Aggregate Awareness in Universe Lets see what is this aggregate awareness functionality and how it is useful in universe. Client says that report is taking long time to run?
Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2013 (1) ► December (1) ▼ 2012 (6) ► November (1) ► October (1) ▼ June (1) Merge So this explains when merge dimension works as Full outer join and when it works as left or Right outer join. Michael, i tried your solution but still the #datasync error when i try to put objects from different Data Providers(same universe) in one block?00 Any other ideas? 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
Alert Moderator Like (0) Re: #DATASYNC error while merging two different quires anil . Hope it clarifies - Good luck_________________Marc Remember the suffering of past generations - Think on the challenges of the next - Pass altruism along.