hi Cognos Experts Pls Expalin me what is the diffence
between list report query and crosstab report query?pls
explain me.....
- 1 Answers
- 4955 Views
- HCL, I also Faced
- E-Mail Answers
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 |
What do you understand by ‘ibm predictive maintenance and quality’?
Tell me about Dnamic and Static Dashboards?
how to explain health care project and which reports we can create in health care doain?
Can you define dimension?
what is an sid (surrogate key)?
---------------How to identify First Record and Last Record?
What do you mean by Drill down and Drill Up?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
diff b/w grouping and aggregation
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What is meant by junk dimension?
HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
Teradata 
