GeekInterview.com
Series: Subject: Topic:
Question: 110 of 275

How do you link different data providers in a single report?

Asked by: vasanth96 | Member Since Jul-2007 | Asked on: Jul 11th, 2007

View all questions by vasanth96

Showing Answers 1 - 10 of 10 Answers
rav123

Answered On : Jul 25th, 2007

Linking of data from two queries is a typical case where data is extracted from two different sources, which do not have a predefined cardinality (normally from two different data providers). It is necessary that the dimension you use to link data providers be the same type (numeric or alphanumeric) in both data providers.

  
Login to rate this answer.
Ghungroo

Answered On : Jan 30th, 2008

View all answers by Ghungroo

we can link the data coming from 2 different dataproviders through sync option available in Reporting environment.One can link a dimension from one Data provider with the other using "LInk to" and "Unlink" options provided there.

  
Login to rate this answer.
neha1985

Answered On : Feb 13th, 2008

View all answers by neha1985

Go to data tab -> new data provider -> access new data in different way, link the common dimensions .

  
Login to rate this answer.
Ravi Teja N

Answered On : Sep 16th, 2011

The simply way is create universes individually using the data providers.Then link the universes.

  
Login to rate this answer.
Nithya

Answered On : Sep 21st, 2011

How do u link different data providers in a single report ??

- The concept used to perform this is Data synchronisation, using Merging Dimensions tool provided in BO.

  
Login to rate this answer.
bharat

Answered On : Dec 25th, 2011

BY using add query we can add muitiple data providers but we must have common dimensions to link those two

  
Login to rate this answer.
lionskashif

Answered On : Aug 28th, 2012

View all answers by lionskashif

To my understanding, you are talking about two Different Query which is fetching data to 2 different Source(like Universe). so, that means you need to MERGE the result into One Report. If yes, then you need to use Merge Dimension option. In order to use this option you should have at least one common dimension in both Queries with same data type.

Hope you got it.... lionskashif

  
Login to rate this answer.
Vyankatesh valakate

Answered On : Oct 19th, 2012

Using Hierarchies

  
Login to rate this answer.
hari

Answered On : Nov 7th, 2012

Use the merged dimensions to link the data providers. It will give you a dialog for the selection of the dimensions in both data providers. select the dimensions which are alike and merge.

  
Login to rate this answer.
shashank chakraborty

Answered On : Dec 13th, 2012

We can link different data providers in a single report by merged dimension.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.