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
How to deploy from one server to another server?
1. Explain your project.
Why cognos decision stream is used?
What do you understand by the term 'dynamic cube'?
What is main difference mapplets and mapping?
------------- How to identify the Revenue Column in Report?
what are the dimensions that you have in your current project?list them?
How do we convert from Numeric to be Words?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
how to perform back drill through in cognos 8 what is the use of it
What is the complex report you faced in real time?
explain how to create powerplay reports?
What is defined as data mining?
What is the difference between drill through, drill across?
Explain what is the difference between native sql and cognos sql?