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
What is model?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Define the cognos reporting tool?
Can you define cognos decision stream?
Can you define metrics designer?
What are the components of the report studio?
What errors and types of errors you faced in Cognos ReportNet?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Can you explain new content durability?
What is meant by junk dimension?
What is a Transformer?
What are the different uses of a repository manager?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
Define report item?