COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: danasellers@udayton.edu on 24 Feb 2010 10:11:16 AM

Title: left outer join always brings back null
Post by: danasellers@udayton.edu on 24 Feb 2010 10:11:16 AM
Hi gurus,

I don't know if this is a famework manager question or a report studio question.  I have a package that joins two tables as 1..n  0..n  however, when I attempt to show a column from the 0..n table it's always null. I tested the relationship in framework manager and it brings back data and I also copied the code into my sql tool and looked for the specific record I needed and it found it.  What have I done wrong?

Thanks a bunch for any advise!

Dana
Title: Re: left outer join always brings back null
Post by: danasellers@udayton.edu on 24 Feb 2010 10:13:00 AM
ok, never mind - quick fix I found join wasn't showing properly.  Sorry to be a bother.