What is #DATASYNC error how to remove it?

Answer Posted / sunnyodc

This error come when you fetch more than 1 dimensions from
2 joined 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 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 ?    44 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In banking domain how many Fact tables,Dimension table are present?

8566


What sort of existing documents should business analysts refer to when starting on a new project?

775


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

759


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1786


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9813


Explain what are the steps to do to use alerts in bo?

794


What is the profile and package?

2052


What task is 98% of the required work of a business analyst?

767


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1754


What is difference between webi and infoview?

870


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1683


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2040


Differences between business objects and web intelligence reports?

841


Explain what are the steps to be taken to schedule the report?

824


can anybody tell me about complicated object you have created

2944