Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is Stitched Query in ReportNet?

Status
Not open for further replies.

gotike

Technical User
Mar 7, 2004
7
US
Hello All,
What is Stitched Query in ReportNet? and how to eliminate them? Please help me on this.

Thanks,
sunny
 
A stitched query is generated in reportnet when running multi-fact queries across conformed dimensions.

Why do you want to eliminate them?
 
additionally, in the cognos sql, you will find the key words:

coalesce

(...

)

full outer join

(..

)

if you are seeing stitched queries, then i would say your model design is good as it would seem that you are follwoing best pratices.. as JGirl said, why would you want to remove them?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top