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

How to join tables in framework manager?

Started by cognoshelp@ymail.com, 02 Jul 2008 07:22:59 PM

Previous topic - Next topic

cognoshelp@ymail.com

I need to join 2 tables which don’t have common column.


miwis

Hi,

What kind of join do you want? 1 to 1, 1 to n or n to n?
Do you know any mathematical/sql expression to join this tables (i.e. always after comma etc.)?
If yes - you have 2 ways (1:1, 1:n):
1 - add a column with extracted values and join on this query item with second table,
2 - add relationship between tables in FM (don't create any link) and in expression window write join syntax.

Michal
--
Michał Wiśniewski
ACCRE, Cognos BI Consultant