Answer Posted / bhaskar.nagi
The SQL generated by Cognos 8 known as a stitched query.
Stitch query in cognos to avoid full outer joins. If you are
trying to model a full outer join involving two fact tables
related through a common dimension table, note
that Cognos 8 will handle such situations using a stitch
query, which does not require that you model any of the
relationships as an outer join. As of my understanding, this
is kind of after importing metadata, when we are giving
joins or relationships between the queries, for better
performance and to be not confusing in giving the joins we
will be breaking the query to multiple queries or merging
two queries in to one query. those queries are called
stiched queries.
Is This Answer Correct ? | 11 Yes | 12 No |
Post New Answer View All Answers
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What errors and types of errors you faced in Cognos ReportNet?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
what are the errors faced while bursting the reports and how to solve those errors?
what is degenerate key in oracle ?whare do we use it?
What DB View and Bus View?
What is cognos connection?
Can you explain cognos planning?
What is the function of model design accelerator?
What are the components of the report studio?
Can you define set to be cardinality?
Can you define cognos powerplay?