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

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,

---

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

1 Answers   IBM,

---

How to create model and how to test model?

0 Answers  

---

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

0 Answers  

---

what is Cognos Visualizer and Cognos Scripting?

3 Answers  

---

1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?

2 Answers   IBM,

---

1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?

1 Answers   IBM,

---

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

0 Answers  

---

architecture of cognos8

1 Answers   IBM, Sonata,

---

How can we improve performance in report studio level?

1 Answers  

---