u drag 2 sources from 2 diff dataproviders,how we take
these 2 sources into 1 single report,
how we give the link these 2 sources

Answer Posted / suvarna

You can do a trick. Suppose u have different objects in
two data providers (lets dpA and dpB),dpA have product
related objects for example product code, product name and
dpB have customer related objects.U drag a object from a
dp, lets take dpA.Now when u try to drag a object from dpB
u will not be able.
For this , go to the tool bar->view data->definations->
link the object u want to drag(say customer name from dpB)
with any object from dpA ->select Ok.Now u will be able to
drag the customer name from dpB. U will see that data
displayed in the report is not correct.Now again go to view
data and unlink the objects->select Ok.
Now u will get the correct data in the report.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1817


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1615


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1749


Can you please send me the migration related issues .

1651


what are the day to day activities of BO administrator ?

1980






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

617


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


What is a bo repository?

596


Explain in detail about type 2(scd),

598


what is the difference b/w the refresh and buffered data?

1765


what is universe null

1991


U r project in which stage in implementation?

1950


what are the tables used in health care domain project and columns used in report?

4039


What are the join problems comes appart from loop,chasm & fan Traps

1556