Print Page - Join / Union

Title: Join / Union
Post by: kado on 01 Jul 2009 02:02:57 PM

Any idea why Cognos only allows you to join (or union) 2 queries at a time? I can't figure it out and am curious.

-thanks-

Title: Re: Join / Union
Post by: Suraj on 01 Jul 2009 08:13:17 PM

You can UNION as many queries as you want. Only JOIN is limited to two at a time. I think it is to reduce sql complexity and incorrect data aggregation.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kado on 01 Jul 2009 02:02:57 PM