Sign Up Login


  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

How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers   Cap Gemini, TCS,

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

2 Answers  

Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

0 Answers  

When is the Repository created?

1 Answers  




what is the source for metrics?

2 Answers  

how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in

2 Answers  

1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

1 Answers   Virtusa,

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,

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,

what is the difference between bo and cognos?

1 Answers  

For more Business Objects Interview Questions Click Here
Categories