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
- 9568 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 |
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
How do you test the reports? Explain the Unit testing procedures after developing the reports?
How to pass parameter value into html design page?
difference between imprompt and reportnwt1.1
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
9. What was the most complex type of report you dealt with?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Explain the Difference Between Bursting and Scheduling?
Can we install cognos on windows 7?
How do we create Links & Segments in Cognos Framework Manager?
pls any body give the cognos 8 versions release year.
Teradata 
