Always two columns are joined by left outer join by defualt

[inu]

Hi
I set the cardinality as 1:1 <-> 1:1 at report level while joining, still , it takes left outer join..

Can you plz let me know the issue.


Thanks
Inam

[AnalyticsWithJay]

Hi Inam,

Check your FM model. The query subjects you're pulling from likely have a left outer join to another table that's needed.

Though you may have an inner join between your final two queries, the paths that Cognos will take to retrieve the data items within each of the final queries is dictated by the model.

Jay