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 |
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
What is a category?
What are the advantages of Xcelsius & Crystal reports over Infoview?
When we are going for Shortcut join and why.
How will solve a loop caused by lookup table without using alias?
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
If there is no common dimension? Is it possible to combine two different dataproviders?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
how to restrict up to three levels in hierarchy when u do drill mode?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
What is the architecture of ur project? can u explain it? PLz