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 are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
what is the role of cognos comsultant?what actually it means?pls reply
What is the use of powerhouse?
Name the types of gateway?
What is Online View?
What is the use of powerplay web viewer in cognos?
Can you define folder?
What is set to be Cognos configuration?
what are the special features in cognos reportnet?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
what are slowly changing dimensions? Why we are used scd?
What are the types of hierarchies?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
How do you improve the performance of the Cognos Analytics report