Combining data providers

[koune]

Hi,

I have data coming from 2 dataproviders
* 1 universe based on SQL-Server
* 1 free-hand sql,based on an Oracle database

Dataprovider 1 contains a table with employee_code and employee_name.
Dataprovider 2 contains a table with employee_code and PlaceOfBirth.

I link the employee_code field between both dataproviders...

Problem: It isn't possible to show employee_code, employee_name and PlaceOfBirth in one single table in BO. It is possible to show employee_code with name, or employee_code with PlaceOfBirth...but is just not possible to show the three fields in 1 table.

Does anyone know the solution for this problem?

Thanks in advance,
Koen

 

[blom0344]

Hello Koen,

BO lets you combine DIMENSIONS from separate data-providers in 1 body (table/crosstab) if ALL dimensions are of the linked kind. In your case you will have to redefine the dimension that is not linked as a DETAIL ( by defining it once more in the universe, but then as a detail instead of a dimension) and you'll see that it is than possible to use one table for all 3 objects.

T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[pabloj]

http://www.techsupport.businessobjects.com/

you must be a customer to enter this site Stick to your guns

 

[koune]

I am a customer, but even there (BO techsupport) you can't find the answer.