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.
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