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



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

what is profile and packages in BOXI??

1 Answers  


what is confirm dimension ?

11 Answers   IBM, Wipro,


what is isolated joins in check integrity

2 Answers   Accenture, Polaris,


you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,


1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

1 Answers   BNP Paribas,






how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

2 Answers   TCS,


HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?

3 Answers  


How you get the requirement from client?

3 Answers   TCS,


BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,


Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,


hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  


generally how do we get information for creating universes and reports

1 Answers   Satyam,


Categories