#datasync Error In Business Objects Report
Contents |
SAP BusinessObjects Web IntelligenceWhere is this place located?All Places SAP BusinessObjects Web Intelligence 4 Replies Latest reply: Jun 10, 2014 11:04 AM by Bala Manoj Kumar Gade Tweet #DATASYNC error while merging two different quires anil . Jun 6, 2014 11:50 PM
Business Objects Merge Dimensions Datasync
Currently Being Moderated Hi All, I am on SAP BO 4.1 SP2 Patch2 , datasync error in webi I am trying to build a webi report on top of 2 different bex quires . I Merged on company code-Key from
#context Error In Webi
both the quires. Made query 1 as the primary query (a,b,c) and created the details objects (x,y,z) for dimensions from query 2.The brought in the merged Company code to report and fields directly from Primary errors in webi reports query (a,b,c) , when I bring the fields from query 2 (x,y,z) . I am getting #DATASYNC error . 1.How to over come the # DATASYNC Error and what should be passed in for associated Dimension while creating the details for (x,y,z) . I am not able to find the Merged Dimensions (Company code- Keys).2.If I check the "Avoid duplicate rows aggregation" , I am getting the values . Is merging dimensions in business objects it the best practice to show the duplicate row aggregation (or) we need to always uncheck the option . Which is the best practice ? 3. After checking the Avoid Duplicate row aggregation, I always ends up with the "Unable to get the first page of current report. Check the validity of report"Kindly find the errors below. Please suggest me the best practice to follow , while working on multiple bex quires . Suggestions Highly appreciated.ThanksAnil 2978Views Re: #DATASYNC error while merging two different quires Bala Manoj Kumar Gade Jun 8, 2014 3:43 PM (in response to anil .) Currently Being Moderated You have defined merged dimension on 'company code-Key' which is common in both the Bex-queries.You are able to bring the merged dimension and other objects from Query_ One to report block without any issue but when adding objects from Query_Two you are getting the error #DATASYNC.In this case objects from Query_One are got sync with the merged dimension object without any issue because they got added first to it.Similarly when you add merged dimension and objects from Query_Two you find no issue, because objects from Query_Two go sync first.Once objects from a query(Query_One/Query_Two) got added to a merged dimension, when we try adding objects from other query
Business Objects Suggest New Category What is #DATASYNC error how to remove it? Question Posted / sunnyodc 2 Answers 30612 Views IBM, TCS, I also Faced E-Mail Answers Answers were Sorted based on User's Feedback
Extend Merged Dimension Values
Answer / sunnyodc This error come when you fetch more than 1 dimensions from #error in webi 2 joined queries. if you are merging 2 queries , you can pull all objects of 1st query , but only one dimension object
Webi Merge Dimensions Outer Join
from 2nd query. you can use merged object from 2nd query but not the other ones, if you want to show remaining objects of 2nd query make a measure variable of each dimension. that means put them in new variable and http://scn.sap.com/thread/3567163 define that variable as measure. now bring them on report. select table go to property click the option > show rows with empty measure values. Is This Answer Correct ? 39 Yes 12 No Answer / amit rathi #DATASYNC :#DATASYNC occurs when you place a dimension from a different dataprovider in a block containing dimensions from another data provider, and the two data providers are not synchronized through a merged dimension. #DATASYNC appears in all dimensions in the block and http://www.allinterview.com/showanswers/138226/what-is-datasync-error-how-to-remove-it.html #CONTEXT in the measures. Example: Dimensions from different data providers in a block If a report based on the Island Resorts Marketing universe contains data providers with the objects (Year, Revenue) and (Quarter), a block containing Year, Quarter and Revenue displays #DATASYNC in the Year and Quarter columns because the two data providers are not synchronized through a merged dimension Is This Answer Correct ? 20 Yes 2 No Post New Answer Categories Teradata (205)Business Objects (780)Cognos (888)Informatica (1801)Crystal Enterprise Suite (29)Actuate (36)Ab Initio (209)Data Stage (636)SAS (599)Micro Strategy (41)ETL (208)OBIEE (45)Data Warehouse General (219) More Business Objects Interview Questions IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT? 2 Answers Rolta, Clover, What are the types of errors you faced while creating a report from two different data providers 3 Answers IBM, Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx 4 Answers What are the diffrences between Business Objects 5.1 & 6.5 ? 1 Answers Siemens, What is the Computation error? how to solv it? 1 Answers What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way? 2 Answers CTS, what are the day to day activities of BO administrator ? 0 Answers TCS, How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff
webi report, so that we can use them in same block. Mandatory condition to merge objects is to have same data type. For eg. See below tables , coming http://gsaxena-bobj.blogspot.com/2012/06/merge-dimensions-in-webi.html from two different queries in webi report. Query 1 Query 2 Now if you http://www.dagira.com/2009/09/03/using-forcemerge-to-fix-unbalanced-data-providers/ try to use all these objects in same block , you will get data sync error.(As webi will not be able to find any relation between these queries) I will now merge empid and cust id. Merge Id is showing all rows coming from emp id and cust id and their corresponding revenue error in and salary column values. This is now showing results as Full outer join. But if I involve any one non-merged dimension in this block, the results will start showing dimension values pertaining to that query only. So basically it is working as Left or Right Outer join when we try to use any dimension in the block which is not merged. But we will not be able to error in webi use both emp name and cust name in same block as these are not merged. We will get data sync error if we try to use them in same block. Similarly if you don't use merge id column and use emp id or cust id along with revenue and salary, that will work as Left or Right outer join and not as Full outer join. So this explains when merge dimension works as Full outer join and when it works as left or Right outer join. There is also one option which makes the functionality of left or right outer join to work as full outer join. i.e. Extended merge dimension. (note:- but this works only when unmerged dimension is not selected in the block) See for below example. When I used cust id revenue and salary, the block look like this: So its showing data as left outer join . Now I will check the option"Extended Merge Dimension" from document properties. 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 and not merged object in the blo
Techniques, Variables!, Web IntelligenceDave Rathbun @ 7:30 am I have discussed the MultiCube() function a number of times in my series of Variables presentations. In certain situations it allows you to fix measure objects when you have two (or more) unbalanced data providers in a full-client document. ForceMerge() is the equivalent for Web Intelligence. So how do they work, exactly? What do I mean by unbalanced data providers? How is it fixed with these functions? Are there any special conditions to be aware of? Merged Data Provider Review I recently published a blog post that described unbalanced data providers. If you want the full description, I have included a link at the end of this post. If you want the executive summary, here it is: When you have two (or more) data providers in the same document and want to merge the data, you have to link them using dimension objects. If you don't have the same number of dimensions from each data provider, then they are unbalanced. That can cause issues. It took me twelve hundred words (and six pictures) to provide a detailed explanation in my earlier post. In the sample report I used for that post I had one common dimension (Year) and one unique dimension from each side (Resort and Region). I showed how I could use Year with either measure since it was a shared (and linked) dimension. I also showed how (and explained why) trying to use the "extra" dimensions like Region or Resort caused problems. I don't intend to repeat everything here; please use the link at the end of this post to read the prior post if you are unclear on anything so far. What About MultiCube()? One of the comments I got on that post suggested that MultiCube() could be used to fix the issue. My response was accurate as far as I was concerned, but later when I read it again I realized it could also be quite confusing. 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 t