Answer / nisha

List Query is simple select Query
Where as Cross tab query will have group by function used.

List will show data in detail level.
Crosstab will show data in summarized level.

For ex:

List

Product Price Year
1A 12 2012
2B 10 2011
1A 23 2011
2C 45 2012
1A 50 2011

Crosstab
Year
Product 2011 2012
1A 73 12
2B 10 0
2C 0 45

How to create a dynamic column name in Cognos?

6 Answers   Aditya Birla, Polaris,

---

cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  

---

difference between boxtype and visiable

1 Answers   IBM,

---

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

0 Answers  

---

what is report burn and where it occurs

3 Answers   IBM, Target,

---

---

Name the types of report?

0 Answers  

---

can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,

---

------------ Diff b/w MemberCaption and MemberDescription?

0 Answers  

---

Can you define cube?

0 Answers  

---

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'

2 Answers   Cap Gemini,

---

What are the advantages of cognos?

0 Answers  

---

what is the generated prompt,how can i use?

5 Answers  

---