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

write a query to display to 10 max record from the employee table?

7 Answers   HCL,

---

What are the types of folder present in cognos?

0 Answers  

---

what is cube size?

4 Answers   IBM,

---

You get a parsing error when you run a report. What will be your first steps to resolve the error?

2 Answers  

---

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 Answers  

---

---

How to create model and how to test model?

0 Answers  

---

what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,

---

what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,

---

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  

---

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

3 Answers  

---

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,

---

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

0 Answers  

---