hi Cognos Experts Pls Expalin me what is the diffence
between list report query and crosstab report query?pls
explain me.....
- 1 Answers
- 4957 Views
- HCL, I also Faced
- E-Mail Answers
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 Inline Query?
What is the difference between static and dynamic conditions?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
How can create users and permissions in cognos?
Please explain the different stages in creating a report in cognos report net?
What are the themes in a data warehouse?
Explain the different types of views used in cognos.
Can you define fan trap?
What are all the different types of prompt in cognos?
How to publish a package by running Java Script?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
When we save a report in report studio with what extn it save?
What are products of cognos?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
How can you link a query to a data container manually in Report Studio?
