What is Stich Query in Reportnet?

Answer Posted / joydeep

when we pull in facts from different tables into the report
that might be joined using a conformed dimension, cognos
does a combination of coalesce and full outer join to
create a stitch query to avoid the loss of data. when you
go through the SQL generated for the report if you see a
combination of coalesce and a full outer join that means
you are dealing with stitch queries.

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is requery in cognos?

2070


How to Reset Pagenumbers in one report.

2214


What is zero-foot print?

598


What are the components of report net?

740


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2163






Can you define fan trap?

757


What are the roles defined by cognos platform?

570


What do you mean by query studio?

517


What are initial page components of Cognos connection?

612


Can you explain dynamic query mode?

592


What are the two types of framework manager?

686


How do you Parametermap variables in Quiries?

1779


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1503


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1957


What is difference between page break and section report?

686