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

Relationship in Framework Manager

Started by saranya, 27 Jan 2014 12:57:52 PM

Previous topic - Next topic

saranya

I have a relationship like below.

LEFT OUTER JOIN
                 tableA
ON
                tableB.col = tableA.col1 AND
                tableC.col = tableA.col2

The problem is that the relationship involves 3 different tables (tableA, tableB, tableC), how can I create this relationship in Framework Manager? we can create relationships between only 2 tables but this relationship uses 3 tables.

charon

hi,
besides the fact that outer joins are costly even with good indizes and statistics and therefore an etl solution might be an option to evaluate, i dont see the issue creating two join paths in fm. in case you realy need just two tables and a view or another etl action  is far from reach, you are able to "fuse" two or more cognos fm query entities (like tables) based on a defined join path and by doing so, you create a "virtuel" table. If i recall correclty, thats a optimized solution for this szenario because the cognos fm engine will produce an effective (minimized) sql.
but im not sure on the last part, just "urban" knowledge, maybe some more experienced cognos user will be able 2 deliver more detailed information.
anyhow, gl and best regards