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
Can you define slice?
Name the types of gateway?
Can you define confirmed dimension?
What is an olap designer?
Can you define snapshot?
WHAT ARE THE DISTNICT VARIABLES?
What is the difference between the standard and metrics folder?
What are the ways to import data into catalog?
Define the cognos reporting tool?
2. What functional area you worked on.
What is Bitmap Index?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
Why are meta service important then other services?
What junk dimension contains?
What is defined as Cognos Impromptu?