Multiple Queries in the Report Query

[Mpotla]

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!

[DustPanMan]

What do you mean by Query splits?  Outer joins?

[blom0344]

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?