Interested to Buy Any Domain ? << Click Here >> for more details...
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 other methods working as deployment functionality?
What is set to be Cognos configuration?
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 ?)
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Can you define fan trap?
Define the slice and dice?
How can I test reports in cagonos?
what is the main advantage of impromptu over cognos reportnet?
How do you Parametermap variables in Quiries?
How do you call a store procedure within a transformation?
What r the names of the reports that you prepared?
Can you define a query subject?
