u drag 2 sources from 2 diff dataproviders,how we take
these 2 sources into 1 single report,
how we give the link these 2 sources
Answers were Sorted based on User's Feedback
Answer / kvchowdary
by using data synchronization process..that means....
synchronization is the term used to describe the merging of
data from multiple data sources into a single block in a report
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / suvarna
You can do a trick. Suppose u have different objects in
two data providers (lets dpA and dpB),dpA have product
related objects for example product code, product name 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.
For this , go to the tool bar->view data->definations->
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 ? | 6 Yes | 0 No |
Answer / sunil sethi
Both of the above answers are correct.it get linked
automatically if the objects have the same name in 2 data
provider.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi
Basically we merge objects from two or more queries in one
webi report, so that we can use them in same block.
Mandatory condition to merge objects is to have Same data
type
Normally Merged dimension will work as Left or Right outer
join and not as Full outer join.
If you want to use Full outer Join you can use extended
merge dimension Values option in document properties .
| Is This Answer Correct ? | 0 Yes | 0 No |
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
How do you find what type of trap is there by seeing the report?
11.what are the features in BO?
What are the difference between merge,auto merge and extended merge ?
How to link one location universe to other location universe
what is Scope of Analysis
Explain how we drill up week to month?
What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function
6 Answers Cap Gemini, Deloitte,
What is the prm file ? can anybody explain me ?
Why do we need metrics and sets?
What is a universe?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?