Interested to Buy Any Domain ? << Click Here >> for more details...
In framework Manager, what is a stitch query and is it good
or bad?
- 2 Answers
- 9575 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sureshkumar
In cognos Stitch query is very useful. When we pull data from 2 different fact table using conformed dimension, cognos will create full outer join with 2 fact table and use coleace function to get first non null values.
For example:
I have actual sales(Actual Sales Fact) and target sales(Target Fact table) and Time dimension. Here time dimension is a conformed dimension.We may have target for particular period and we may not have actual sales for that period. so in this scenario if we use inner join only matching records will come but we need target sales even though there is no actual sales. thats why cognos will make full outer join and use coleace to get first non null values.
Month Actual Target
201401 300 400
201402 null 300
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasanthi.u
in frame work manager, stitch query is nothing but it will
stitch the two querys.
for example i have 2 querys like Q1 and Q2 and i stitch these
2 querys and found Q3 with the full outer join
| Is This Answer Correct ? | 1 Yes | 4 No |
What do you understand by the term 'dynamic cube'?
How to create a Ratio in Cognos Report studio Reports?
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.
can you tell me what are the dimension tables are used in project
------------- How to identify the Revenue Column in Report?
--------------Explain Table of contents?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what is the difference between filter and condition?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What is the difference between List and Cross tab? Could some on explain with an example..
what is loop in frameworkmanager ?
How can we Maintain the Cube Security by Category level and Dimension level ?
Teradata 
