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 |
how many user were there
Tell me the difference between cmc and cms?
Explain how many universes can be created in a project?
solve the following loops? dimension table fact table fact table dimension table link will be there between tables?
How to delete the duplicate colums in a sql table ?
What is meant by data federator and what is the use of it?
Explain is there any other repository domains rather than universe, security, document?
How many built-in objects are created in Business Objects repository?
while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?
Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace