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 are the different uses of a repository manager?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What do you understand by the term 'aggregate advisor?'
What is the difference between the content store and content manager?
What are all the components of Report Studio?
What are types of batch available in cognos?
Define datastores in cognos?
What are all the types of indexes in Cognos?
Can you explain a cognos controller?
What do you understand by the term 'aggregate cache'?
can we insert all types of charts in a list report? what r the realtime prompts?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
How we check the errors before running the report?
What are the components of report net?
i was asked what are the caluclations done by you in your report? plz give reply