Print Page - Always two columns are joined by left outer join by defualt

Title: Always two columns are joined by left outer join by defualt
Post by: inu on 06 Sep 2016 09:14:37 AM

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

Title: Re: Always two columns are joined by left outer join by defualt
Post by: AnalyticsWithJay on 06 Sep 2016 10:25:56 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 06 Sep 2016 09:14:37 AM