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.

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

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

---

What is a category?

3 Answers  

---

What are the advantages of Xcelsius & Crystal reports over Infoview?

1 Answers   Reliance,

---

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

---

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

---

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?

1 Answers  

---

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,

---

If there is no common dimension? Is it possible to combine two different dataproviders?

7 Answers  

---

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.

1 Answers   Accenture,

---

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,

---

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,

---

What is the architecture of ur project? can u explain it? PLz

1 Answers   Patni,

---