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