Answer Posted / joydeep
when we pull in facts from different tables into the report
that might be joined using a conformed dimension, cognos
does a combination of coalesce and full outer join to
create a stitch query to avoid the loss of data. when you
go through the SQL generated for the report if you see a
combination of coalesce and a full outer join that means
you are dealing with stitch queries.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
explain how to create powerplay reports?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
how you migrate reports to cognos 8 from previous versions?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
Explain is there any comparison available for cognos reportnet vs crystal reports?
Can you define report item?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Can you define folder?
-----------------What is Determination Model?
What are the services provided in cognos 8?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is the metric store database?
What are the types of catalogs in cognos?
-----------With out using DrillThrough how to do Reports?