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

Report with 2 fact tables

Started by adoremars, 28 Jan 2012 02:20:58 AM

Previous topic - Next topic

adoremars

Hi All,

Let's say I have a dimension table and 2 fact tables. Dimension table is connected to both the fact tables and I have not done a fact to fact relation here. My reporting requirement is to have dimensions from dimension table and facts from both the fact tables. I hope Cognos will handle this using a stitch query and in my case by default a full outer join is happening. between these 3 tables.
But I wanted an inner or left outer join as per my requirement. I'm not sure how a determinant works here. Can anyone guide me in this regards?

Appreciate an early suggestion. Thanks much...

blom0344

At least add unique determinant for the dimension table. Stitch query will by default use coalesce and full outer join.  However the resultset can be reduced by using individual filters in the report