hi Cognos Experts Pls Expalin me what is the diffence
between list report query and crosstab report query?pls
explain me.....



hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report..

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

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More Cognos Interview Questions

What are the types of studio?

0 Answers  


how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..

2 Answers   Wipro,


What do you understand by ‘ibm predictive maintenance and quality’?

0 Answers  


explain project, package ,model , modelers.........and differences b/w them?

4 Answers   HCL,


Tell me about Schemas?

4 Answers  






What is the use of powerhouse?

0 Answers  


----------------------What are the User Securities?

0 Answers   IBM,


diff b/w grouping and aggregation

1 Answers   HCL,


Define datastores in cognos?

0 Answers  


How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,


How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

4 Answers   Mphasis,


What is Crossproduct?

2 Answers  


Categories