Back to top BaazigarPrincipal MemberJoined: 10 Jun 2004Posts: 420Location: New York Posted: Fri May 09, 2008 1:58 pmPost subject: Re: Merge Dimensions - #DATASYNC I need to do this in WEBI. I am looking for how-to papers to do this but all the posts bring me to your blog🙂. That can cause issues. Reply Raj says: September 1, 2011 at 7:50 AM Thanks for the article. "Auto-Merge dimensions only works within a universe" helped me think of the solution to my problem in a click site
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 I will create a new variable with this formula: =ForceMerge([Number of guests]) I will replace my "broken" measure with my new variable and observe the results. Can you merge the dimensions from queries 4 and 5, and give the merged dimension a different name, like ‘Fam' and ‘SubFam'? 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
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? These two objects have the same name, and are from the same universe. Here's the details. Continue working with the same document.To manually merge dimensions with different names In the Java Report Panel Edit Report view, ensure that the Reporting toolbar is displayed.
Comment by Ken February 18th, 2016 at 2:26 pm Dave, Six and a half years after your original post and you're still solving problems! Hierarchical Data Here is what I consider to be a really good example of why this is a problem. Watch out for trailing blanks. Merging Dimensions In Business Objects 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. Tip 1: Adding “Incompatible” dimensions to the block Have you ever noticed that, sometimes when you try to add a dimension to a block that includes merged dimensions, you sometimes get I have a Fan Trab problem and I don't know hot to resolve it. Reply Diane Spargo says: April 28, 2016 at 8:58 AM Thank you for a quick response.
If not, you can get unexpected results. Extend Merged Dimension Values My first data provider has dimension values Country and Resort and the Revenue measure. Using forcemerge is not giving us the correct results. But funny thing is when I dropped this detail object at the end of the table means just after the last object in the table it gives data and at some
Tip 3: Values displayed depend on which object is used Sometimes, the values between two merged dimensions don't completely match. Reply Jody Tucker says: February 20, 2014 at 3:20 PM Hi Michael… We've spoken before, but it's been quite some time. Datasync Error In Business Objects Reply swati says: February 27, 2013 at 4:44 AM Thanks for this great artical on merge dimension. #context Error In Webi 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
Again, no limit. Kari-Anne says: April 4, 2013 at 3:01 AM Hi, Thank you for a informative post, Tip 1 have been of great help. Display any measures coming from any query; 3. Have you tried that? Errors In Webi Reports
But will it know if I want the aggregation happens at higher level? But this one explained it all. I'm trying to add Queries 4 and 5 to the same report (which have a different sales reporting time frame) and merge the ‘Family' and ‘Sub-family' dimensions only between 4 and navigate to this website then what is the difference between forcemerge and forAll /For Each ?
Below and to the left is a list of the merged dimensions that already exist in the document: in this example, we see Store name, which is a dimension that was #error In Webi Revenue is still okay because the Country object was part of the query context of that data provider. I mean anywhere.
Reply Surya says: May 2, 2013 at 9:31 AM Thanks Michael..for your detailed Explanation on Merged dimensions Reply Ranjith says: May 6, 2013 at 1:55 PM Hi Michael, We have Query1 cisty should have higher level of granularity compare with state, since granularity is about the level of detail Reply Michael Welter says: April 15, 2014 at 12:05 PM Actually, it's just Any number of queries can be linked by common dimension objects. Webi Merge Dimensions Outer Join I'm not able to merge variables am I?
So this explains when merge dimension works as Full outer join and when it works as left or Right outer join. But our case is quite complex. Created block with State, Quantity, Revenue and creating input control on category, But Revenue is not influencing if you change the category.? my review here As defined, with the format "Q1″ and "Q2″ and so on, there is no indication as to which year the quarter revenues are coming from.
Also, make sure that you use the Merged dimension in the block. Kan Reply Michael Welter says: April 10, 2014 at 11:47 AM Kan, Since you don't have Gross Sales at the state level in a query, Webi won't be able to roll There is one for posts, and another for comments. Aggregate Awareness in Universe Lets see what is this aggregate awareness functionality and how it is useful in universe.