Home > Error In > #datasync Error In Business Objects Report

#datasync Error In Business Objects Report

Contents

Mike Noel Scheaffer says: June 28, 2012 at 2:27 PM This a very well-written and informative post. 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 ... You don't always have to convert the un-merged dimensions to Details…. 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 click site

Tried by creating detail variable for Category and then created input control on it, but no luck… we have relationship for State to Category is 1:N. ForceMerge() is the equivalent for Web Intelligence. That's where the ForceMerge() function comes into play. From Wikipedia: Children in the United States and Canada often count ‘One-Mississippi, two-Mississippi' during informal games such as hide and seek to approximate counting by seconds.

Business Objects Merge Dimensions Datasync

Now I need to merge the two merged queries on that line of business to get the grand totals. 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 Related Links Blog Post: What Are Unbalanced Data Providers… And Why Should I Care? 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

There is no reason why the merges should delete themselves, and there are other reports I've performed the same task with and their merges remain intact. Drill down from one data provider, then swap to the other, switching measures when appropriate. Nice to chat with you again. Merging Dimensions In Business Objects Info which you mentioned in Tip3 is like left, right and full outer joins.

If you want the full description, I have included a link at the end of this post. unfortunately I need to filter on a field thats only on one of the queries in the merged dimension - sorry, should have made that clearer. If that's what you mean by "include a dimension which is not part of context/block" then you are correct. I love my job.

For eg. Extend Merged Dimension Values If you display the Product Number object from Query 1, you will see all the Product Numbers from Query 1. Please type your message and try again. Tip 2: Auto-Merge dimensions only works within a universe Web Intelligence has a feature called "Auto-merge dimensions".

Datasync Error In Webi

Now, when I take the my objects in my block Report, The 100 rows returned by the second query are displayed. I haven't changed my data providers. Business Objects Merge Dimensions Datasync Use that new merged dimension in a new report: You can bring in measures or details into the new report. #context Error In Webi Thanks.

It does the same as using the Merged Dimension, but doesn't give as much control. get redirected here Make it a detail of the State merged dimension. please help Reply Kirk says: September 8, 2014 at 1:36 PM Thank you very much! Do you know what the rule of thumb is? Errors In Webi Reports

but had to add Query 2 - [GL Transaction Person or Vendor IDr ]. Set a group of Testing user IDs in the system, and apply the restriction set to them. Login Register Follow SCNJive Software Version: 5.0.6.2 , revision: 201308121150.54f5b14.release_5_0_6_2 : Hi, GuestLog OnJoin UsSearch for: HomeActivity0CommunicationsActions0BrowseMoreContentPeoplePlacesRecent Bookmarks Please enter a title. navigate to this website 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

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 #error In Webi City is a lower level of granularity than State. Do you know if this is possible or not?

Many thanks in advance for your time.

I've spent a fair amount of time on BOB answering questions about this topic. Many thanks, Grace. May 26, 2015 6:30 PM (in response to JC H) Currently Being Moderated Hi,I found the following link by Michael very helpful. Webi Merge Dimensions Outer Join Q2.obj1 has a set of values (B,D,G,H,I).

Related Filed under Web Intelligence 81 Responses to Tips for MergingDimensions KFonMurphi says: April 19, 2011 at 4:27 AM Hi, About "Extend merged dimension values" (tip 4): it's useful to get Otherwise, I'm going to have to make a new report for this data, though it would make more sense in the current report. Unless it can tell the difference somehow, it's not appropriate to apply the function automatically. http://sovidi.com/error-in/datasync-error-web-intelligence.php select table go to property click the option > show rows with empty measure values.

Thanks, Reply Michael Welter says: March 25, 2013 at 9:35 AM Thanks, Reddy. That is what I meant by data being unbalanced "downwards" in my comment on my prior post. I tried your suggestion and am still having problems. 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

Reply Aaron says: April 15, 2014 at 12:03 PM Thank you Micheal it is veray useful. It was wonderful reading your posts. Perhaps do you have a little time to help me… I have 3 tables that are linked as follows: Client -< Account -< Account_Transactions
Client
======
Client_ID

Powered by Blogger. has resorts Hawaiian and Bahamas, U.S. 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 If you do not set the Document property to Extend Merged DIm values, you get #multivalue Reply Dave Rathbun says: April 20, 2011 at 7:02 AM Hi, Michael, I wrote a

Is this possible? Comment by Sumon October 30th, 2012 at 1:58 pm Dave, you should have some option in your blog so that we can subscribe there and each time you post something, we Thanks Lawton Comment by Rahul July 12th, 2011 at 2:01 pm Hello Dave, Really impressed with your in depth knowledge!!!! It's difficult for me to quite understand the whole situation.

Grand Total will always be the sum without the filters applied. Thanks! Go ahead and think a bit, I can wait. What a great place to work!

If you display the Product Number object from Query 2, you will see all the Product Numbers from Query 2. Advanced Join Property Advance join property in universe is present , when you click a join between any two tables and click on Advance button. 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. 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