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
Why cognos scenario is used?
what is power prompt in cognos ep7series?what is the use of this?
What junk dimension contains?
What are the methods by which it non-durable model could be changed into the durable model?
What is cognos connection?
difference between impromptu and cognos8
What is Bitmap Index?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
What is zero-foot print?
What is the importance of having monitor service in cognos?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
How create measures and dimensions?
How to create a cube in Transformer? What is the process? Please mention process thank u
can you tell me what are the dimension tables are used in project