If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Join three table via an Expression Filter

Started by jcuiskelly, 25 Jan 2007 03:37:15 PM

Previous topic - Next topic

jcuiskelly

Does any know how to join three tables with out using an SQL statement?Ã,  This is what I am trying to do.Ã,  I need 'Y' from table 'CC' and Table 'AA' has nothing in common with Table 'CC'.Ã,  So, I am trying to use Table 'BB', which has common fields between Table 'AA" and Table 'CC'.Ã,  'X' from Table 'AA' equals 'X' from Table 'BB', 'Y' from Table 'BB' equals 'Y' from Table 'CC'.

MFGF

Hi,

I don't think this is possible from within Cognos Query.  The joins would need to be set up in Architect then the package republished.

Regards,

MF.
Meep!

jcuiskelly

Thank you for the information.Ã,  :)