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 I always wondered why anyone would use that "feature". Of course, you and I both know that each State only has one State Capitol, so it's not really a lower level of granularity. Values are case-sensitive. my review here
Reply dorai says: December 16, 2013 at 4:12 AM Hi , Rit now we are showing data at territory level and We have an requirement to show at rep level.means who Using forcemerge is not giving us the correct results. Please let me know if I misinterpreted… 2) How to hide a column in Web XIR3.1 dynamically? I think of it this way: They used to have two different applications, one for the desktop, and one for the web, that were designed to do basically the same thing,
Like in your above example, if a filter is applied based on country and you create a grand total row, then grand total of ForceMerge([Number of guests]) won't reflect the applied Company Code Key as the associate dimension.You can drag all the detail objects along with the merged dimension and measures. I guess I have to live with it..
It just means that you have an incompatible object in the query. Translate Picture Window template. 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 Merging Dimensions In Business Objects Please advise.
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 Datasync Error In Webi I'll do some more testing and if I determine the fix, I'll post it. In order to display the data from all three data providers in one report, do they need to have a common dimension across all three? Blog Post: "Smart" aka Database Delegated Measures What was that "Mississippi" thing earlier?
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 Extend Merged Dimension Values 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 But which list of product numbers will appear on the report? When merging dimensions and a corresponding detail (in Deski) everything works fine when using either the dimension or the detail information in the report.
Give that a try. Reply Richard says: October 11, 2012 at 11:13 AM I have a Business Objects Server configured with two seperate ODBC connections (they point to two seperate databases; one Test and the Business Objects Merge Dimensions Datasync But if you do, you will need to manually merge them. #context Error In Webi I'm not able to merge variables am I?
Conclusion Merging dimensions is the only way to combine data from different data sources in the report. this page The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension. In certain situations it allows you to fix measure objects when you have two (or more) unbalanced data providers in a full-client document. Web Intelligence Server Configuration Virtual Machines Universe Design Dynamic Dates Fan / Chasm Trap Foodmart Join Techniques Prompts Recursive Data Universe Contexts VBA Tools Recent CommentsDynamic Dates Part I: Yesterday and Errors In Webi Reports
Reply Jon Fortner says: May 1, 2012 at 4:12 PM Michael, I used two Character Dimensions that have the same type of data from two different universes. I just wanted to know , can we get by with lower degree dimensions by making them details to a dimension which can be merged?? I actually solved it by filtering on an "object from another query". http://onlinetvsoftware.net/error-in/datasync-error.php ForceMerge() is the equivalent for Web Intelligence.
There is one for posts, and another for comments. #error In Webi Take a look at the data and tell me how you would break out the quarter data into different years. Now, when I take the my objects in my block Report, The 100 rows returned by the second query are displayed.
select table go to property click the option > show rows with empty measure values. Is there a way to do that. The complicated part is understanding just what the function does and when to use it, rather than how to use it. Webi Merge Dimensions Outer Join 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.
Please type your message and try again. 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 Have you tried that? useful reference Thanks in advance for your feedback- David Reply kristaldoyle says: November 21, 2014 at 6:04 AM Hi Michael, thank you so much for the informative post regarding merged dimensions.
Thanks Lawton Comment by Rahul July 12th, 2011 at 2:01 pm Hello Dave, Really impressed with your in depth knowledge!!!! How would the function determine the difference between the data configuration in this post and the one in my prior post where I talked about unbalanced data providers? 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... Mike says: July 28, 2015 at 9:15 AM I'm having a similar issue as Jon and Kari-Anne.
Then create a restriction set in that universe that includes a connection to the test database. You'll need to get the State added to that universe. lv Show Balances or Transactions Flag ------------------------- =If(IsError(Sum([Actuals]ForceMerge([Actuals])) In ([GL Ref]));"T";"B")
Comment by glains January 14th, 2010 at 11:14 am Hello Dave, First, thank's for this blog! Thanks in Advance 2 Answers CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)? 2 Answers For more Business Objects Interview Questions Click Here
Nice to chat with you again. Otherwise, I'm going to have to make a new report for this data, though it would make more sense in the current report. After all, merging dimensions is one of the most powerful features of Web Intelligence. Comment by ram May 31st, 2011 at 3:16 pm I have a scenario where query1 has country and resort, query2 has country and revenue.
Yet there are some cases where I can fix unbalanced data providers. Set a group of Testing user IDs in the system, and apply the restriction set to them. Comment by Mark Duffill May 16th, 2010 at 4:21 am Thanks for the clear explanation, I had not properly understood that function previously. Comment by Dave Rathbun April 12th, 2010 at 2:05 pm Hi, I saw that you posted the same question on BOB.
So this explains when merge dimension works as Full outer join and when it works as left or Right outer join. Thanks Reply Caralie Ringholz says: June 5, 2013 at 8:09 AM This is my first time trying to use a merged dimension and am not sure if it's even the correct 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. Comment by Lawton July 5th, 2011 at 5:05 am Hi Dave, ForceMegre function helps a lot.