What is #DATASYNC error how to remove it?
Answers were Sorted based on User's Feedback
Answer / 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 |
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 ? | 22 Yes | 4 No |
what is diff between webi,deski,infoview
Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
What is the use of Surrogate key in BO?
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....
What is drill across ? can anybody explain me in detail?
Explain what is the difference between slice and dice and cross tab report?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
can i use stored procedure in webi?
what is zero client and thin client ?
how to overcome overflow of data in a report
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?