#datasync Error Web Intelligence
Contents |
SAP BusinessObjects Web IntelligenceWhere is this place located?All Places SAP BusinessObjects Web Intelligence 8 Replies Latest reply: May 26, 2015 6:30 PM by Dee J. Tweet Datasync error in Webi Alexey datasync error in business objects Veselov Oct 11, 2012 1:31 PM Currently Being Moderated Hello!Could you please
Webi Datasync
help with such a problem:I have 2 Bex data sources:Query 1Query 2Hierarchies:- Date1- Accounts1Dimensions:- Year1- Month1- Account1Measure:- ActualHierarchies:-
#context Error In Webi
Date2- Accounts2Dimensions:- Year2- Month2- Account2Measure:- PlanI want to merge both queries in one report.Step 1. I merge the dimensions: year1 to year2, acc1 to acc2, month1 to month2. So
Errors In Webi Reports
I've got 3 merged dims: Year, Month, AccountStep 2. I generate the tableX Axis: Date1 (Hierarchy from Q1), Month (Merged dim)Y Axis: Accounts1 (Hierarchy from Q1), Account (Merged dim)Body: Actual, PlanAnd everything is OK.Step 3. 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 merging dimensions in business objects Axis: Accounts2 (Hierarchy from Q1), Account (Merged dim)Body: Actual, PlanThen there is an error #DATASYNC error in all the parts of the table(Picture attached)Thank you! datasync.JPG 32.3 K 20810Views Tagsnone (add) Tags: error, report, bex, bw, hierarchy, web_intelligence, webi Re: Datasync error in Webi Simone Caneparo Nov 8, 2012 3:47 PM (in response to Alexey Veselov) Currently Being Moderated you get the #DATASYNC message because the engine is unable to synchronize the two dataproviders. it is not sufficient to declare the merged dimensions and hierarchies are more complex than it seems so you are using a non supported workflow. Alert Moderator Like (0) Re: Datasync error in Webi Mark Singley Nov 8, 2012 10:04 PM (in response to Alexey Veselov) Currently Being Moderated You'll get a datasync error if you try to use an object from each query. The common way around this is to create a detail object, which is very simply =Accounts2, which is a detail of the merged dimension. I'm not 100% this will work on a hierarchy- but that's how you
Business Objects Suggest New Category What is #DATASYNC error how to remove it? Question Posted / sunnyodc 2 Answers 30614 extend merged dimension values Views IBM, TCS, I also Faced E-Mail Answers Answers were Sorted based on #error in webi User's Feedback Answer / sunnyodc This error come when you fetch more than 1 dimensions from 2 joined webi merge dimensions outer join queries. if you are merging 2 queries , you can pull all objects of 1st query , but only one dimension object from 2nd query. you can use merged object from 2nd https://scn.sap.com/thread/3250192 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 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 http://www.allinterview.com/showanswers/138226/what-is-datasync-error-how-to-remove-it.html 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 #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 IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me 2 Answers Accenture, What is detailed Object 1 Answers IBM, IN THE REPORT I WAN
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 http://gsaxena-bobj.blogspot.com/2012/06/merge-dimensions-in-webi.html , coming from two different queries in webi report. Query 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 error in and their corresponding revenue 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 in business objects 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 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