Print Page - Multiple Queries in the Report Query

Title: Multiple Queries in the Report Query
Post by: Mpotla on 27 May 2009 10:02:59 AM

Hi All,

I have a query which i migrated from CRN to Cognos 8.3, When i chk the join in the Framework looks fine, but when i fetch SQL of the report its giving Query splits.

Please suggest me , what might the reasons for Multiple queries.

Thanks in Advance!

Title: Re: Multiple Queries in the Report Query
Post by: DustPanMan on 27 May 2009 11:13:34 AM

What do you mean by Query splits? Outer joins?

Title: Re: Multiple Queries in the Report Query
Post by: blom0344 on 27 May 2009 02:48:35 PM

C8 automatically performs a split whenever it detects multiple facts. It determines a fact as fact if all joins are set to n:1 from the perspective of the fact. With proper use of determinants it should stitch correctly back. Did you check the tabular dataset to see if it returns a meaningful set?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mpotla on 27 May 2009 10:02:59 AM