You'll need to get the State added to that universe. However, the synchronized block is only able to display data at the Year level. The only link between the 2 queries is the GL Reference Nbr which is not a key to either table. Alert Moderator Like (0) Re: #DATASYNC error while merging two different quires anil . http://onlinetvsoftware.net/error-in/context-error-in-web-intelligence.php
The Guests measure fails because it is now being viewed out of context. (At the risk of becoming tedious, I will point out one last time that this issue is covered but I am looking for equi join… Could you please let me know how we can display data if i want to see data similer to equi join. If not, you can get unexpected results. Comment by akhilannan November 6th, 2013 at 10:29 am Dear Dave, I see that if I create a grand total row and apply some filters to the table, the filters won't
We have merged both queries on State. Unbalanced upwards can be fixed with the ForceMerge() function as detailed in this post. Here once again is the help text for the ForceMerge() function: Forces Web Intelligence to account for synchronized dimensions in measure calculations when the synchronized dimensions do not appear in the Reply Michael Welter says: October 3, 2012 at 12:44 PM Don, Webi only automatically merges when the exact same dimension object appears in multiple queries.
A measure object can be synchronized successfully only to the lowest level of detail that is common between the two different data sources. Email check failed, please try again Sorry, your blog cannot share posts by email. %d bloggers like this: Next, I will explain how to fix it. Merging Dimensions In Business Objects Is there a tutorial that can describe this method in detail?
Here's what I said: …the MultiCube() function will help if data providers are unbalanced “upwards” but not “downwards” … After reviewing my response, I realized that it was quite likely that Webi Datasync It won't let me merge them in the first place, since I've already merged the same dimensions in queries 1,2 and 3. Scope of Analysis Seems very small topic, but I have seen people with different understanding about its functionality in Business Objects. Yet if I create a query with the Quarter and Revenue from the Island Resorts database here is what I get.
I will link the two data providers by Resort as it is the only common dimension. Extend Merged Dimension Values What a great place to work! Summary The magic of the ForceMerge() function (or if using Desktop Intelligence the MultiCube() function) is that it changes the behavior of the report engine. http://www.dagira.com/2010/06/19/what-does-extend-merged-dimensions-really-do/ Reply Michael Welter says: April 20, 2011 at 3:30 PM Thanks, Dave.
If that's what you mean by "include a dimension which is not part of context/block" then you are correct. Reply Grace says: June 2, 2015 at 7:38 PM Thanks for replying. Datasync Error In Business Objects Since version XI3.1… Read More » Category: Tips and Tricks BIAR file in Business Objects 4.x BIAR files are no longer used in BI4.x for the same purpose as we used them #context Error In Webi I have a Fan Trab problem and I don't know hot to resolve it.
Merging dimensions in Webi works much differently than linking dimensions in Deski. Most people think of time as a really clean hierarchy. Mike says: July 28, 2015 at 9:15 AM I'm having a similar issue as Jon and Kari-Anne. My document will have two data providers from the Island Resorts Marketing universe. Errors In Webi Reports
Storage tier 5. I was trying to get the table to show blanks for cells that didn't have a match in the other query on Product names. 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 http://onlinetvsoftware.net/error-in/datasync-error.php The Store dimension has been positioned as one of the objects included in the merged Store name object Click OK to close the dialog box.
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 #error In Webi This way is much better. (Despite which, I still wish that Webi would allow hiding of columns, eg to allow sorting of a report on a dimension that is not displayed) The only way to match the granularity between all three data providers, there must be at least one common dimension between them all.
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 Michael Welter says: April 24, 2013 at 7:28 AM Kari-Anne, sorry for the slow response. You don't always have to convert the un-merged dimensions to Details…. Webi Merge Dimensions Outer Join Tip 3: Values displayed depend on which object is used Sometimes, the values between two merged dimensions don't completely match.
Merge Dimensions: [v_Merged Ref No] Query 1 [Contribution GL Reference No] Query 2 [GL Transaction Person or Vendor IDr ] [v_Merged Donor ID] Query 1 [Contribution Donor ID] Query 2 [GL 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 Only display dimensions (one or more...) that are synchronized through all queries participating in the table; 2. http://onlinetvsoftware.net/error-in/datasync-error-in-business-objects-report.php I merge the dimensions: year1 to year2, acc1 to acc2, month1 to month2.
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 Here we will take a look into the important new features of Web Intelligence Reports. Thank you for sharing! I replaced =ForceMerge([Number of guests]) with =[Number of guests]ForEach([Resort]) Comment by satish January 14th, 2013 at 4:30 am can we link two dataproviders from two universes in business objects Comment by
Therefore, it's a very powerful feature, especially if you understand how it works, and how to make it work. Let me explain why this happens, and then we'll look at ideas on how to fix it. Could you please suggest me here.. That's where the ForceMerge() function comes into play.
Do you have any ideas how to resolve this ? but about the granularity. Lets say I have two tables customer and daily ... And I found this page, demonstrated in http://www.youtube.com/watch?v=EfxCO01XNhM Comment by Suhasini May 15th, 2012 at 12:25 am Hi Dave, If forcemerge brings the dimension in context while calculating the measure,we can
By using one of these functions I can specify that linked dimensions still have to be considered by the measures even if those dimensions no longer appear in the block structure. Reply Michael Welter says: March 29, 2013 at 4:13 PM Thanks for the kind words, Brad. Web Intelligence indicates that you could choose to merge the selected object with any of the other dimension objects in the document's queries. Am I missing something here or is this a limitation of Webi?
Make it a detail of the State merged dimension. 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 Sorry if I missed the answer in the article above. 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.