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

Explain what is the difference between slice and dice and cross tab report?

609


What three things do you consider to be the most important factors for a manager?

604


In banking domain how many Fact tables,Dimension table are present?

8383


What are the steps to be taken to schedule the report?

558


any difficulitis have you phase while creating bo reports and how did u solve it

2997






What is a bo repository?

596


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

626


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

1556


what is xcelsius architecture?

3747


what is document design in boxi,have u participate in that

1663


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

635


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1973


What is difference between custom hierarchy and report based hierarchy?

553


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1573