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

What is Report item

1 Answers   TCS,

---

how u will determine the performence tune will occur either in report or system

0 Answers   Ness Technologies,

---

what is mean by cognos powerhouse?

1 Answers   TCS,

---

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.

5 Answers   HSBC,

---

How to pass parameter value into html design page?

1 Answers  

---

Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar

2 Answers  

---

Use of Text Source Variable in Report Studio?

2 Answers  

---

How to connect three fact tables?

11 Answers   L&T, TCS,

---

Hi Experts, Can a single package be shared by multiple users?

3 Answers  

---

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

0 Answers   Satyam,

---

Can you define set to be cardinality?

0 Answers  

---

What is portal page?

5 Answers   TCS,

---