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
What are the steps to do to use alerts in bo?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Can you please send me the migration related issues .
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain how we drill up week to month?
What is aggregate table and aggregate fact table ... Any examples of both?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How to execute the plsql procedure from the report by clicking with mouse?
Which versions are used in the bo dashboard work?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Can we Save (save as) WEBI Doc as DESKI?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain about a time when you discovered a more efficient way to do a work task?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...