Object synchronized when using different universe. Reply Michael Welter says: June 5, 2013 at 8:14 AM Hi, Caralie. It is splitting the revenue at random between the resorts and displaying incorrect data. (E.g. Richard; I haven't seen this happen. http://performancepccanada.com/error-in/error-in-business-objects.php
They have three data providers, each one uses a different universe. 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 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 To make query Synchronization work with a table: In the table: 1.
Many thanks in advance for your time. Any idea how to do a workaround? Please type your message and try again. Query synchronized when different universe c.
Please type your message and try again. Doesn't make any sense to me. 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 Merging Dimensions In Business Objects It always works the same.
This article provided answers I could not find anywhere else. Pls. Reply Reddy says: March 19, 2013 at 6:39 AM Hi Michael, It is really great article on ‘merge' option. Note that the detail variable must be a detail of a merged dimension.
Q2.obj1 has a set of values (B,D,G,H,I). Extend Merged Dimension Values You should then be able to add that variable to the block, and get what you need. How will forcemerge display the data? I didn't even change the block structure, other than to replace the broken measure with my corrected calculation.
Each transaction has a debit and credit resulting in 4 GL detail transactions): Both Records: [Contribution ID] = 154806 [Contribution GL Reference No] = DN154806 1st Record: [Contribution Donor ID] = Create a detail variable with =[GL Account Nbr] as the formula. Business Objects Merge Dimensions Datasync 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 ... #context Error In Webi Which is the best practice ? 3.
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 have a peek at these guys 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 And finally, thank you if you read this entire message! Yet there are some cases where I can fix unbalanced data providers. Errors In Webi Reports
Alert Moderator Like (0) Re: #DATASYNC error while merging two different quires anil . I have created rep detail object on territory as associate dimension object.here problem is same rep assigned two differnt terrotories.whne i tried to use detail varible I am also getting Multi You can add dimension objects from both data providers, but onle in DeskI not in webi Thanks Mukul Back to top Marc DoucetPrincipal MemberJoined: 11 Jul 2007Posts: 360Location: Montreal, Quebec, Canada check over here Translate Picture Window template.
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. #error In Webi Let's say there is a set of Region and there Revenue like below: Region Revenue East Japan 1,012,727 Bav... Thanks in Advance 2 Answers CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)? 2 Answers For more Business Objects Interview Questions Click Here
You can only have one dimension from each query in a single block. I need a report of the contribution information selected in ‘Query 1' along with all accounts affected from ‘Query 2', including account number, and debit / credit amts. When I used cust id revenue and salary, the block look like this: So its showing data as left outer join . Webi Merge Dimensions Outer Join Unbalanced upwards can be fixed with the ForceMerge() function as detailed in this post.
Do we have to apply any patch for this? Instead, make a variable – in this case we made a detail objects associated with the Pennid: And you can use that new variable in your new report (in this case Display any measures coming from any query; 3. this content 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
If you have Car Make and Sales Amount from one query and Year from another and try to build all three in a block, you will get a #DATASYNC error because You can not post a blank message. The way we tell is as follows: Create a detail variable. If you're looking for help on a topic you have already posted on BOB then please do not repost your question here.
However, we found that, as "food" contained all the records within "fruit" & "meat", only the sub total of food can be show and the sub total of "fruit"&"meat" will leave You don't always have to convert the un-merged dimensions to Details…. 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 ? If you want to see all values from Query 1, and only values from Query 2 where there is a match on Products, then merge the two queries on Products, but
Info which you mentioned in Tip3 is like left, right and full outer joins. Each contribution can affect multiple accounts on the GL side. 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 country U.S.
Let's say that I have - Query 1 with: SO | Order Date | Item - Query 2 with: PO | Order Date | Item | Delivery Date I have linked Here's an example of a merge that will not happen automatically. 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 The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension.
Many thanks, Grace. It seems to be ok, but I don't want that ! You cannot merge using variables.