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

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 you mean by drill across?

0 Answers  

---

what are the names of the reports that you prepared?

0 Answers   IBM,

---

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  

---

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

---

what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,

---

15. If I select the current month and year how can we display previous 11 months data?

2 Answers   TCS,

---

What is main advantage datawarehousing over oracle?

0 Answers  

---

What is the difference between filter & Condition?

4 Answers   IBM, Polaris, TCS,

---

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

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  

---