Answer / kruthi

stiched query sends two seperate queries to data siurces
and merge them internally.

Answer / cherry

when we have multi facts objects involved in our report,
Cognos will generate two separete queries with each Fact
table and combine them with FULL OUTJOIN. These queries are
called Stitched queires.

Answer / saj

A query that uses multiple facts from different underlying
tables is split into separate queries for
each underlying fact table. Each single fact query refers to
its respective fact table as well as to the
dimensional tables related to that fact table. Another query
is used to merge these individual queries
into one result set. This latter operation is generally
referred to as a stitched query. You know that
you have a stitched query when you see coalesce and a full
outer join.
A stitched query also allows IBM Cognos software to properly
relate data at different levels of
granularity

Answer / santhosh kumar s

When dimension is joined with two fact tables this stitched
Query takes place.
EX: Say table Dim_Product ,fact_retail sales and fact_sales
If we write query for this like dim_product inner join with
fact_retail sales and inner join with fact_sales
Result:We will get wrong data(will get multiplied with one
record with all the records in other table)
To over come this:
Should write two seperate queries and should join them .
Result:Will get required data

Answer / bhaskar.nagi

The SQL generated by Cognos 8 known as a stitched query.
Stitch query in cognos to avoid full outer joins. If you are
trying to model a full outer join involving two fact tables
related through a common dimension table, note
that Cognos 8 will handle such situations using a stitch
query, which does not require that you model any of the
relationships as an outer join. As of my understanding, this
is kind of after importing metadata, when we are giving
joins or relationships between the queries, for better
performance and to be not confusing in giving the joins we
will be breaking the query to multiple queries or merging
two queries in to one query. those queries are called
stiched queries.

-------------How to create a PortalTab?

1 Answers   Cap Gemini,

---

Which service handles requests for cognos connection,query studio and event studio.

2 Answers   TCS,

---

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

0 Answers   CTS,

---

What is the function of cognos dispatcher?

0 Answers  

---

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,

---

---

What are all the different types of prompt in cognos?

0 Answers  

---

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers  

---

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

5 Answers   Satyam,

---

What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?

1 Answers  

---

what are determinants?

4 Answers   Dominion,

---

What are the other methods working as deployment functionality?

0 Answers  

---

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

2 Answers   IBM,

---