HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO
YOU LINK THEM?

Question Posted / tprasad

4 Answers
8861 Views
CitiGroup, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?..

Answer / augustine

Yes. When you pull data from different data souces, if the
dimension name is same then they get linked automatically.
Ex. You have "Month" in one DP1 and Month in another DP2
they get linked automatically. i.e. a Join is created
between the two. If the name is not same then we need to
link them in Data Manager.

Is This Answer Correct ?

5 Yes

1 No

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?..

Answer / sateesh

we have to take two data providers dp1,dp2
first we have to do in webi report
eg in our database emp,dept we have generate two
connections and export it
then
take dp1 ename,dept,sal then run query
after u can click edit query option then u click on
addquery then in the screen appers dilog box with 3 options
in that u have to select any option like 2nd onr then
click ok query2 ename,dept.com then run it
then
in that report panel insert one column then drag and drop
another measure comm

Is This Answer Correct ?

1 Yes

0 No

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?..

Answer / satya

we can work with different datasource through Business view.

if we are creating two universes and linking them , they
should have created on one data source.

Is This Answer Correct ?

0 Yes

0 No

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?..

Answer / shiva shankar sheela

you can create different universe for different sources and
link them in BO.

Is This Answer Correct ?

1 Yes

6 No

Post New Answer

More Business Objects Interview Questions

what is stacked chart , Bar chart, Column chart?

1 Answers Tech Mahindra,

what is difference between folders and category ?

4 Answers Tech Mahindra,

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers

What is detailed Object

1 Answers IBM,

what is the source for metrics?

2 Answers

What is the Computation error? how to solv it?

1 Answers

how to create reports on screech?

0 Answers Zensar,

What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

3 Answers Perot Systems,

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?