IQD pulls in unwanted joins

[buzzheal]

Hello,

I have created a package in Architect, from a star schema database, that contains several fact tables and several lookup tables. When I select columns from several lookup tables and only one fact table my IQD, generated from Cognos Query, contains joins to multiple fact tables. I have double-checked all of the joins in the Data Access, Business, and Package Layers, and I cannot figure out why the IQD is pulling in these extra joins to more than one fact table. There are no columns selected from these additional fact tables. Any ideas? Thanks!

 

[DoubleD]

If the lookup tables are joined to more than one fact table, Cognos Query will allow a join path from one lookup table, through a fact table, to another lookup table. Its a matter of Cognos Query making poor decisions when building the SQL. The only way to avoid this is to create views of your dims, or create a single Cognos Query package for each fact table.

Pain is stress leaving the body

DoubleD