Author Topic: Relationship in Framework Manager  (Read 1120 times)

Offline saranya

  • Associate
  • **
  • Join Date: Jan 2014
  • Posts: 1
  • Forum Citizenship: +0/-0
Relationship in Framework Manager
« on: 27 Jan 2014 12:57:52 pm »
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.

Offline charon

  • Statesman
  • ******
  • Join Date: Nov 2011
  • Posts: 398
  • Forum Citizenship: +19/-3
Re: Relationship in Framework Manager
« Reply #1 on: 27 Jan 2014 04:01:50 pm »
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

- knuffel the muffel in the puffel -

 


       
Twittear