Outer Joins in Synchronised data providers

building semantic layer
1

Possibly missing something simple -

I have data coming from two universes, say Col A from Universe A and Col B from Universe B.

The objects are linked Col A to Col B.

The default action of synchronisation is for a combined result set to show only those records where the values are in Both A and B.

What I need is for an outer join so that the result set is all values in Col A and those in B where they match.

ie
Col A Col B
A A
B B
C
D D
E
F F
G G

I can’t see an obvious way to do this especially since it is going between two universe so sub-queries etc can’t work.

Perhaps synchronisation isn’t the right way to go about it.

Regards

Jonathan

Project Leader
Global Medical, Regulatory and Product Strategy (GMRPS) IS

Listserv Archives (BOB member since 2002-06-25)

2

I’ve had this problem myself very recently. If your data sources are all ODBC (i.e. not Oracle SQL*Net or similar) then you could use Microsoft Access, with linked tables to provide a ‘virtual’ database containing the tables you require. You can then do an actual outer join between them.

Perhaps an ‘outer’ type of synchronisation is required… and Business Objects folks listening?

Cheers,

Phil Morris
Analyst Programmer
BITS dept.
Tarmac Heavy Building Materials UK Ltd.
PO Box 8
Ettingshall
Wolverhampton
West Mids
WV4 6JP

Tel: 01902 382183
Email: pimorris@tarmac.demon.co.uk

“My own opinions are not necessarily those of my employer…”

From: Cirkel, Jonathan D[SMTP:jc14547@GLAXOWELLCOME.CO.UK] Sent: 05 August 1998 11:55

Possibly missing something simple -

I have data coming from two universes, say Col A from Universe A and Col B from Universe B.

The objects are linked Col A to Col B.

The default action of synchronisation is for a combined result set to show only those records where the values are in Both A and B.

What I need is for an outer join so that the result set is all values in Col A and those in B where they match.

ie
Col A Col B
A A
B B
C
D D
E
F F
G G

I can’t see an obvious way to do this especially since it is going between two universe so sub-queries etc can’t work.

Perhaps synchronisation isn’t the right way to go about it.

Listserv Archives (BOB member since 2002-06-25)

3

I’ve had a similar problem when trying to link an excel spreadsheet to a query based on a key field.
I shows me both the rows that match and the rows that do not match with blanks in them.
Is there a workaround ??

Venu Chakrapani
Project Leader
Lucent BusinessObjects Help-Desk
(w)(847) 673 0900 x129
venu@dunnsys.com

I’ve had this problem myself very recently. If your data sources are all
ODBC (i.e. not Oracle SQL*Net or similar) then you could use Microsoft Access, with linked tables to provide a ‘virtual’ database containing the tables you require. You can then do an actual outer join between them.

Perhaps an ‘outer’ type of synchronisation is required… and Business Objects folks listening?

Cheers,

Phil Morris
Analyst Programmer
BITS dept.
Tarmac Heavy Building Materials UK Ltd. PO Box 8
Ettingshall
Wolverhampton
West Mids
WV4 6JP

Tel: 01902 382183
Email: pimorris@tarmac.demon.co.uk

“My own opinions are not necessarily those of my employer…”

From: Cirkel, Jonathan D[SMTP:jc14547@GLAXOWELLCOME.CO.UK] Sent: 05 August 1998 11:55

Possibly missing something simple -

I have data coming from two universes, say Col A from Universe A and
Col
B from Universe B.

The objects are linked Col A to Col B.

The default action of synchronisation is for a combined result set to show only those records where the values are in Both A and B.

What I need is for an outer join so that the result set is all values
in
Col A and those in B where they match.

ie
Col A Col B
A A
B B
C
D D
E
F F
G G

I can’t see an obvious way to do this especially since it is going between two universe so sub-queries etc can’t work.

Perhaps synchronisation isn’t the right way to go about it.

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
For old 3.1 info:
Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

Listserv Archives (BOB member since 2002-06-25)