I have a situation where the same two tables sometimes need to be outer-joined and at other times need to be equi-joined. In Business Objects 3.1, I solved this by using contexts, one context had the outer join, the other the equi-join. The prompt for context allowed the user to specify which one to apply at the time the query is executed. When
I try to replicate the same scenario in version 4.1.2, I am unable to define the join a second time, that is, I can define it as either an equi-join or an outer join, but not both. In 4.1.2, I can create two contexts but
I can find no way of defining the join a second time for use in the second context. It seems not to consider the possibility that I would want to join the same two tables in different ways at different times.
I posed this question to Bus Obs Tech Support and received a solution (using prompts for components of the where clause) that says it’s only applicable to Oracle; however, I’m using Sybase 11.x. Has anyone out there found a solution that works in Sybase?
If any one is interested, I solved this in 4.x by defining an alias for the table, then equi-joining to one while outer-joining to the other. In retrospect, a piece of cake!
From: Aultman, Steven (SMAU) [SMTP:SMAU@chevron.com] Sent: Monday, November 23, 1998 2:26 PM
(=, *=) in a single universe?
Business Objects 4.1.2
Sybase 11.5
WinNT
I have a situation where the same two tables sometimes need to be outer-joined and at other times need to be equi-joined. In Business Objects 3.1, I solved this by using contexts, one context had
the
outer join, the other the equi-join. The prompt for context allowed the user to specify which one to apply at the time the query is executed. When
I try to replicate the same scenario in version 4.1.2, I am unable to define the join a second time, that is, I can define it as either an equi-join or an outer join, but not both. In 4.1.2, I can create two contexts but
I can find no way of defining the join a second time for use in the
second
context. It seems not to consider the possibility that I would want to join the same two tables in different ways at different times.
I posed this question to Bus Obs Tech Support and received a solution (using
prompts for components of the where clause) that says it’s only applicable to Oracle; however, I’m using Sybase 11.x. Has anyone out there found a solution that works in Sybase?