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
10428 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

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 are the disadvantages of alias?

6 Answers Patni,

how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers

How to Analyise 'Join' problem and which method is the best to resolve that ?

3 Answers

How do u get requirement from the client? in what format?

1 Answers TCS, Wipro,

what is universe testing(not mention check integrity)

1 Answers

What is the degenerated Objects?

2 Answers

What is object stores?

0 Answers

Can we link the Universes from two different sourcess?Explain?

2 Answers IBM, Oracle,

How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

0 Answers

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers Rolta,

For more Business Objects Interview Questions Click Here