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 is the difference between slice and dice and cross tab report?
What three things do you consider to be the most important factors for a manager?
In banking domain how many Fact tables,Dimension table are present?
What are the steps to be taken to schedule the report?
any difficulitis have you phase while creating bo reports and how did u solve it
What is a bo repository?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What are the join problems comes appart from loop,chasm & fan Traps
what is xcelsius architecture?
what is document design in boxi,have u participate in that
What are the steps to do to use alerts in bo?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is difference between custom hierarchy and report based hierarchy?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
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 ?