Datasync Error Business Objects
Contents |
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 Currently sap business objects #datasync Being Moderated Hi All, I am on SAP BO 4.1 SP2 Patch2 , I
Web Intelligence #datasync
am trying to build a webi report on top of 2 different bex quires . I Merged on company code-Key from business objects merge dimensions datasync 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 datasync error in webi 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
#context Error In Webi
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 3020Views 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 q
Business Objects Suggest New Category What is #DATASYNC error how to remove it? Question Posted / sunnyodc 2 Answers 31004 Views IBM, TCS, I merging dimensions in business objects also Faced E-Mail Answers Answers were Sorted based on User's Feedback Answer extend merged dimension values / sunnyodc This error come when you fetch more than 1 dimensions from 2 joined queries. if you are merging 2 queries
#error In Webi
, you can pull all objects of 1st query , but only one dimension object from 2nd query. you can use merged object from 2nd query but not the other ones, if you want to http://scn.sap.com/thread/3567163 show remaining objects of 2nd query make a measure variable of each dimension. that means put them in new variable and 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 http://www.allinterview.com/showanswers/138226/what-is-datasync-error-how-to-remove-it.html 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 #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 I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process 2 Answers Wipro, How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task. 1 Answers Patni, WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY? 1 Answers what are the disadvantages of ali
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 from two different queries in webi report. Query http://gsaxena-bobj.blogspot.com/2012/06/merge-dimensions-in-webi.html 1 Query 2 Now if you 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 and salary column values. This is now showing results as Full outer join. But if business objects 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 use both emp name and cust name in same block as these are not merged. We will get data sync error if error in webi 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 block. Note: this option wont work if you use non-merged dimension in the block. For eg. If you use cust name in the above block it wont work as full outer join. Posted by GS at 17:43 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pintere