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 Reply Bob says: March 21, 2013 at 5:43 AM I'm struggling with totals on a merged dimension value in Webi - when I apply an analysis filter, the totals on my 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 Is there a way to merge the dimensions in Queries 4 and 5 separate from 1, 2 and 3? click site
Comment by Dave Rathbun February 19th, 2013 at 3:30 pm Ah, well, I will watch it but unless they use my actual slides there probably isn't anything to do. When using Merge Dimensions on the GL Reference Nbr I get a total debits and total credits for each contribution disregarding accounts nbrs. I am glad this function is now available in Web Intelligence starting with XI 3.x. For example, State and City might be two dimension objects in your universe.
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? They want to be able to merge all three, however there isn't anything in common between all three. You can only have one dimension from each query in a single block.
It just does not show up in the block. Any ideas? Display any measures coming from any query; 3. Merging Dimensions In Business Objects Comment by Lawton July 5th, 2011 at 5:05 am Hi Dave, ForceMegre function helps a lot.
How is it fixed with these functions? Datasync Error In Webi I have two queries: ‘Query 1' selects data from a donation universe (Donations made to our Co.) based on several section criteria. Yo I decided to give it a shot and ask you. Is there anything Forcemerge can do with this?
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. Extend Merged Dimension Values Comment by ram May 31st, 2011 at 2:56 pm Thank you Dave for the response. Many other fields are also included. I would have expected the SO to be repeated as many times as I have PO, e.g.
Note: this option wont work if you use non-merged dimension in the block. With Webi you can't! Business Objects Merge Dimensions Datasync Check if the multiple queries for each measure are checked. Trying disabling this and see if it makes a difference. #context Error In Webi In this case, maybe we call it Capitol.
Forces Web Intelligence to account for synchronized dimensions in measure calculations when the synchronized dimensions do not appear in the calculation context of the measure I will explain what this means, get redirected here We have merged both queries on State. I am expecting Revenue also should change accordingly when you change ‘Category'. Question Posted / sunnyodc 2 Answers 30612 Views IBM, TCS, I also Faced E-Mail Answers Answers were Sorted based on User's Feedback Answer / sunnyodc This error come when Errors In Webi Reports
If I can't determine how to put things together, how are the numbers going to make sense? Jagpreet Reply Michael Welter says: January 24, 2012 at 8:44 AM Hi, Jagpreet. The other universe contain product information, such as how many apple or orange have been sold. navigate to this website Alert Moderator Like (0) Re: #DATASYNC error while merging two different quires anil .
: Hi, GuestLog OnJoin UsSearch for: HomeActivity0CommunicationsActions0BrowseMoreContentPeoplePlacesRecent Bookmarks Please enter a title. #error In Webi Reply Michael Welter says: February 21, 2014 at 7:38 AM Hey, Jody. If 2 dimensions with different names but same data type we can comfortably merge them. in following case the reason for getting #DATASYNC is Query 1 = ID, Number Query 2 = ID, Date hare
I wonder if you have done some testing merging different types of objects. I am looking for how-to papers to do this but all the posts bring me to your blog🙂. Mike says: July 28, 2015 at 9:15 AM I'm having a similar issue as Jon and Kari-Anne. Webi Merge Dimensions Outer Join 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
It will stay at the level of Customer. So, if I have two queries merged on State, and try to display another dimension, that is not merged, such as State Capitol, Web Intelligence doesn't know how to aggregate the However, perhaps I can make another suggestion: Instead of having two identical universes, pointing to two different databases, you could have one universe, pointing to the production universe. http://gatoisland.com/error-in/datasync-error-web-intelligence.php Can you merge the dimensions from queries 4 and 5, and give the merged dimension a different name, like ‘Fam' and ‘SubFam'?
Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! By default, Webi merges all three dimensions, but i want to un-merge Year. So we have to tell it. I am wondering however if you have suggestions on performance.
So now you know. Next, I will explain how to fix it. Reply Michael Welter says: December 16, 2013 at 9:56 AM Hello, dorai. You can not post a blank message.
If you're looking for help on a topic you have already posted on BOB then please do not repost your question here. But if you do, you will need to manually merge them. So, when you add City to an existing block that already includes State, the measure objects will be aggregated at a lower level of granularity. Thanks, Reply Michael Welter says: March 25, 2013 at 9:35 AM Thanks, Reddy.