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
What is defined as Query studio?
What are the components used in web tier?
hi friends pls forward impropmtu interview question
How to apply securities for reports in cognos connection?
What is the difference b/w macros and prompt?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
How Metrics Studio is better than Report Studio?
Define metrics studio?
how you migrate reports to cognos 8 from previous versions?
write a query to display the departments with no employee?
What is zero-foot print?
-------------What is Coditional Prompting?
Explain about scorecarding?
What is the size of database for you project?
What are the types of catalogs in cognos?