1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / p.srivalli

Answers were Sorted based on User's Feedback



u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how ..

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

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how ..

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

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how ..

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

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how ..

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

Post New Answer

More Business Objects Interview Questions

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

What is the difference between datawarehousing and businessintelligence?

0 Answers  

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

0 Answers   IBM,

it is possible to link two universes of separate functional domain ?

1 Answers   IBM,

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  




What is the pivot option ? what is the need of it?

1 Answers   Infotech,

How can we use multiple data providers in a single report in business objects?

2 Answers  

how to make a report avilable to other users?

2 Answers  

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,

What Is Snow Flake Schema?

0 Answers   Informatica,

Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers

5 Answers   Wipro,

Can we Save (save as) WEBI Doc as DESKI?

2 Answers   HCL,

For more Business Objects Interview Questions Click Here
Categories