hi Cognos Experts Pls Expalin me what is the diffence
between list report query and crosstab report query?pls
explain me.....
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 |
Can you define confirmed dimension?
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
What is the metric store database?
What are shortcuts? Where it can be used? What are the advantages?
what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?
In a Single page we are having 3 list. While running each has to populated in separate page?
What are the Ways to Import Data into Catalong?
2.How do you drill through report from Report Studio to Analysis studio?
How to do Performence Tunning in Cognos Reports?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
Explain about Parametermap?
how to get the all values from a prompt using 'ALL' use and display value in prompt