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

why we r using report studio in webbased only and fm windows based only

1 Answers  

---

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

5 Answers   Mphasis,

---

What are the components used in web tier?

0 Answers  

---

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,

---

---------------Can we use more than 1 Fact table ?

2 Answers   Bank Of America,

---

---

I want to run one page with filter and another page without filter, what is process?

1 Answers  

---

New coloums are added in database, then how you know in report level

0 Answers   Accenture,

---

How will you migrate your reports to QA environment?

2 Answers   Satyam,

---

Which studio is used to create reports?

0 Answers  

---

What is content store?

1 Answers   HCL,

---

What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

1 Answers   IBM,

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---