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

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

i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.

2 Answers   IBM,

---

What do you understand by the cognos?

0 Answers  

---

Main Differnce between Cognos7 and Cognos8

1 Answers   IBM,

---

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  

---

any difference between cognos and real time cognos

0 Answers  

---

what is the difference between rollup aggregation and aggregation ?

1 Answers  

---

How do we implement Check Box Prompt in COgnos Report Studio?

2 Answers  

---

what are the joins present in reportnet?which is most widely used?

4 Answers   Covansys, IBM, Satyam,

---

how to merge 2 crosstabs thans

0 Answers   HCL,

---

In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 Answers  

---

-----------What is member Description?

2 Answers  

---

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

---