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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define set to be cardinality?

591


Can you define slice?

626


5. Which type of report you build more, list, crosstab or chart and why?

1593


how to perform single sign in cognos by using url?

567


Please explain the different stages in creating a report in cognos report net?

569






What is the size of database for you project?

1113


What errors and types of errors you faced in Cognos ReportNet?

3490


What is the information present in the cognos configuration file?

541


How can we create a dynamic column name in cognos?

539


explain how to create powerplay reports?

613


Why are meta service important then other services?

588


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2803


------------- How to identify the Revenue Column in Report?

1823


What is looping and how to avoid it in framework manager?

669


What are the different uses of a repository manager?

605