Interested to Buy Any Domain ? << Click Here >> for more details...
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
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What are query items?
What errors and types of errors you faced in Cognos ReportNet?
Can you define materialized view?
What is the difference between ‘macro’ and ‘prompt?
which type of project we r going to snowflake schema
Explain the difference between native sql and cognos sql?
What is cognos connection?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
where you can save the report net documentation in our local system?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How to publish a package by running Java Script?
What are the steps to import the two data sources in framework manager?
What are the advantages of using cognos sql?
1. Explain your project.
