In framework Manager, what is a stitch query and is it good
or bad?
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 |
is there any possibility to hide items other than render variable?
Can you define framework manager?
what is cardinality that you can give to employee and department query subjects in framework manager?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
Which lifecycle we will use for reporting?
How can create users and permissions in cognos?
What are the different types of OLAP. Which one is Cognos Powercube?
what is Governor settings in cagnos?
Can you define snapshot?
HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
What is difference between drill through and drill down?
What are all types of Batches?