In a report i want to fetch teh data from 2 data Providers.
which condetion wil satisfy to link the 2 data providers.

ex: Q1 have columns A,B,C
Q2 has a X,Y,Z columns.

requirement is like i want to get all the columns from
those 2 tables in report level..like A,B,C,X,Y,Z in a
single report.

Answer Posted / suvarna

You can do a trick. Suppose u have different objects in
two data providers (lets say dpA and dpB),dpA have product
related objects for example product code, product name etc
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
to do that.
For this , go to the tool bar->view data->definitions->
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 ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute the plsql procedure from the report by clicking with mouse?

613


Explain is there any other repository domains rather than universe, security, document?

581


How many universes can be created in a project?

597


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2400


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

814






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

1550


Can you please send me the migration related issues .

1642


What is difference between webi and infoview?

613


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1881


When we use aggregate awareness function in designer?

548


Difference between zabo and webi?

638


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

1759


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3843


Explain when to use local filter and when to use global filter?

603


What are the steps to do to use alerts in bo?

627