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
Explain what sort of existing documents should business analysts refer to when starting on a new project?
how to create metric universe ?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
In banking domain how many Fact tables,Dimension table are present?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is top business?
How to schedule the report in b.o?
What would you consider as your biggest achievement and why?
Explain what are the steps to be taken to schedule the report?
how get the grand total in master-detail report?
How many universes can be created in a project?
What is the difference in creating filters in designer and business objects?
Explain in detail about type 1?
Explain how we drill up week to month?