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

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

Question Posted / tprasad

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

Can any one say me wat does"maintanence of universe" means wit?

2 Answers   Business Intelligence Analytics, NAL, TCS,

I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?

4 Answers  

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

0 Answers  

how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

3 Answers   TCS,

please anyone explain me the derived table with the problem tables.

1 Answers   CTC,




how can u find the granularity in fact table

1 Answers   iGate,

What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 Answers  

What is the slice and dice?

3 Answers  

Explain what are the steps to be taken to schedule the report?

0 Answers  

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

what is universe null

0 Answers   TCS,

How to import BIAR file in bo?

1 Answers   Emirates, Zensar,

For more Business Objects Interview Questions Click Here
Categories