joins

[umag]

Hi

I am using Impromptu Adminstrator 7.0.702.0

I have a problem the way the impromptu parsing the joins. I am looking do I have any control about editing the join strategy?

The situation is like this. I have 3 tables

Table 1
key1
key3

Table2
key1
key2

Table3
key2,key3 is primary

MY Join Strategy:
Table 1 connects Table 2 via key1
Table 1 connects Table 3 via key2
Table 2 conects Table 3 via key 3

My table T3 have key2,key3 comibination is a primary key but none of the Table1, Table 2 have these 2 keys.
So I am connecting them by the above strategy. what impromptu says is there is a loop
and in join strategy it saying it is connecting

Table1 ----> Table2
Table2 ----> Table3
but missing the connection of Table1 -----> Table3. How can I simulate/represent this condition.

where should I edit this?

Quick response is greatly appreciated

Thanks

 

[griffindm]

Can you give us some sample data? Is the primary key to Table3 a concatenation of Key2 and Key3, or is each value represented by distinct columns in the data?

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[gasman009]

I agree, the description is a little confusing. Could you provide some sample SQL?

You probably have done this, but have you looked into adding Table Aliases?