Unable to Create Join in Impromptu

[badhri]

Greetings,

I am trying to create a Catlog and in the join Creation step I have some issues.

After I select the tables and Say 'ADD' the tables come in the botton pane and when I select the columns the "ADD LINK" button is disabled.

When and Why does this happen ?

Badhri ...

 

[Recce]

Hi Badhri

A temporary solution could be the following. It could be because you have recently upgraded. If you still have an old version of Cognos then I would like to suggest that you build your catalog in an old version and then upgrade it to the new version by taking it to the other PC. I have also come across this problem when my operating system was not the latest compatible version for Cognos.

 

[drlex]

Badhri,
It also happens should you choose two columns which are not the same data type.
lex

 

[esselinj]

If the 2 columns are not from the same datatype than you should convert these into 1 using functions. Instead of "drawing"the join as a link you should model it in SQL: something like number_to_string(ordernumber) = Ordercode

 

[badhri]

Greetings,

When the datatypes are different then I did the same way as mentioned. But this also happens for the joins where the datatype is the same.

Does this have anything to do with the Alias tables we create?

Please let me know your thoughts.

Thanks,
Badhri ...

 

[Recce]

Hi Badhri, what operating system and what version Cognos are you using ?

 

[badhri]

I am using Cognos Series 7 Verion2 on Windows XP system.

Badhri ...

 

[Recce]

Hi badhri,

I am not using either of the two so, it is difficult to say however, I have taken a look on the Cognos support site and there seem to be similar problems for other users. All I can suggest is to monitor the reply's in the user support forum. Below is a link to a discussion with a similar problem.Sorry I can't be of more help.

http://support.cognos.com/servlet-c...THREADMESSAGES=1&DOWHAT=DISPLAYTHREADMESSAGES

http://support.cognos.com/servlet-c...THREADMESSAGES=1&DOWHAT=DISPLAYTHREADMESSAGES

http://support.cognos.com/servlet-c...THREADMESSAGES=1&DOWHAT=DISPLAYTHREADMESSAGES