data from two different data providers

building reports webintelligence
1

Hi all,

I’m looking to pull the data from 2 different data providers or universes which don’t have any object’s data in common.

Could you help me with ways to play around?

BO47 (BOB member since 2010-02-18)

2

Hi,

You need to have at least one common column to merge and show the data in 1 table from the different data providers.

M H Mohammed :us: (BOB member since 2010-06-16)

3

So what do you want to do with un-related data …? :reallymad:

BO_Chief :us: (BOB member since 2004-06-06)

4

Hi,

Should have atleast 1 comman data to merge…

regards
GM

tgmurugan (BOB member since 2007-11-20)

5

Hi,

If data from 2 queries (data providers) are really unrelated and you will not try to combine them in 1 data block then go ahead, create 2 queries and create separate tabs/tables for these 2 data sources. There should not be a problem with that.

What other members are trying to say above is that you will not succeed in combining these 2 data sets unless there is something (at least 1 dimension) common in both queries.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

6

Hi BO47.
Agree with Marek…
can you please let us know requirement which may throw some light on the reason you are saying so.

swap_l (BOB member since 2009-04-09)

7

Hi,

Create two separate queries and display data accordingly. Without a common dimension you can’t merge the data from 2 or more data providers.

Cheers,
Suresh Aluri.

sureshbabualuri :india: (BOB member since 2008-03-26)