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
What actually a project contains?
how you migrate reports to cognos 8 from previous versions?
What are the two types of framework manager?
faq's on cognos
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
1. Explain your project.
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
2. What functional area you worked on.
What do you mean by drill through report?
What is called materialized view?
What are types of batch available in cognos?
What are the advantages of using cognos sql?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Define metrics studio?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?