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

Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,

---

Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,

---

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,

---

How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.

5 Answers   IBM,

---

What are the batches and it’s details?

0 Answers  

---

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

2 Answers  

---

what are versions of cognos from starting release to latest in the market?

7 Answers   DELL, IBM,

---

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

---

----------------What is Surrogate Key?

1 Answers   Cap Gemini,

---

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

---

What is minimum version of internet explorer to run the Cognos report.

3 Answers  

---

What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

2 Answers   DELL,

---