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

Questions by vasanth96

Showing Answers 1 - 10 of 10 Answers

rav123

  • 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.

  Was this answer useful?  Yes

Ghungroo

  • Jan 30th, 2008
 

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.

  Was this answer useful?  Yes

Ravi Teja N

  • Sep 16th, 2011
 

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

  Was this answer useful?  Yes

Nithya

  • 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.

  Was this answer useful?  Yes

bharat

  • Dec 25th, 2011
 

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

  Was this answer useful?  Yes

lionskashif

  • Aug 28th, 2012
 

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

  Was this answer useful?  Yes

Vyankatesh valakate

  • Oct 19th, 2012
 

Using Hierarchies

  Was this answer useful?  Yes

hari

  • 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.

  Was this answer useful?  Yes

shashank chakraborty

  • Dec 13th, 2012
 

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

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions