I 'm a novice Business Objects Manager using version 3.1 under Unix/Motif.
I have an application involving marine vessels (ships) that stores VOYAGES in one table, along with a short code for the vessel AND another short code for a lightering vessel (a second vessel that is sometimes used to ferry a portion of the cargo to port). The long name for each vessel is in a separate VESSEL table.
An abbreviated description of the db:
VOYAGE
voyagenumber
vessel_short_code
lightering_vessel_short_code
cargo
etc.
VESSEL
vessel_short_code
vessel_long_name
In raw SQL I get the long name for each vessel by doing a separate join for each, i.e. using either the vessel_short_code or the lightering_vessel_short_code. Is there a way in Business Objects to define a vessel_long_name for both the “vessel” and the “lightering vessel” without having to work from a temp db? I looked at “contexts” but that seems to require you choose one or another and I need both long names in the same query.
Try using table aliases. Create the alias by right-clicking on VESSEL and select “insert alias”.
You can then join the original table(VESSEL) to vessel_short_code and join the alias(VESSEL2) to lightering_vessel_short_code.
Kurt Kerchner
Southwestern Bell
(314)340-9853
From: Aultman, Steven (SMAU)[SMTP:SMAU@CHEVRON.COM]
Sent: Tuesday, August 25, 1998 12:21 PM
I 'm a novice Business Objects Manager using version 3.1 under Unix/Motif.
I have an application involving marine vessels (ships) that stores VOYAGES in one table, along with a short code for the vessel AND another short code
for a lightering vessel (a second vessel that is sometimes used to ferry a portion of the cargo to port). The long name for each vessel is in a separate VESSEL table.
An abbreviated description of the db:
VOYAGE
voyagenumber
vessel_short_code
lightering_vessel_short_code
cargo
etc.
VESSEL
vessel_short_code
vessel_long_name
In raw SQL I get the long name for each vessel by doing a separate join for
each, i.e. using either the vessel_short_code or the lightering_vessel_short_code. Is there a way in Business Objects to define
a vessel_long_name for both the “vessel” and the “lightering vessel” without
having to work from a temp db? I looked at “contexts” but that seems to require you choose one or another and I need both long names in the same query.