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

hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.

2 Answers   WNS,

---

What errors and types of errors you faced in Cognos ReportNet?

1 Answers  

---

what is render variable

5 Answers   Accenture, Cap Gemini, Systime, TCS,

---

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,

---

what is drill down and slicing and dicing what are the difference between them?

5 Answers   IBM,

---

---

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....

2 Answers  

---

how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,

---

what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  

---

How to hide/unhide the prompts which are not used by unauthorized users?

3 Answers  

---

I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?

1 Answers   Facebook,

---

I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

2 Answers   IBM,

---

1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?

3 Answers  

---