Answer Posted / 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 |
Post New Answer View All Answers
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What are slice and dice?
Name the types of gateway?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
How to select multiple values from type-in prompt?
What is difference between page break and section report?
What is the difference between a cascading report and drill through report?
what is stitch query in reportnet?
what is catalog and types of catalogs in cagnos and which is better?
what is the difference between list report and crosstab report?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is the information present in the cognos configuration file?
What is a Query Subject?
--------------Diff b/w ODS and OLAP?
9. What was the most complex type of report you dealt with?