Interested to Buy Any Domain ? << Click Here >> for more details...
What is stitched Query?
- 5 Answers
- 33628 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kruthi
stiched query sends two seperate queries to data siurces
and merge them internally.
| Is This Answer Correct ? | 14 Yes | 2 No |
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.
| Is This Answer Correct ? | 14 Yes | 2 No |
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
| Is This Answer Correct ? | 7 Yes | 1 No |
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
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 11 Yes | 12 No |
What is the difference between ‘macro’ and ‘prompt?
Create 12 columns for months by writing single case statement?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......
1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?
8. Can you use calculations in report headers and footers? How?
16. How can we create top 10 and bottom 10 records in the same list?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is the difference between a cascading report and drill through the report?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
Teradata 
