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 |
While running the reports how can we hide totals if the users doesnot requie it?
What do you understand by the term 'aggregate advisor?'
Can u please describe the different types of traps with eg. Thanks
-------------Diff b/w Union and Unionall?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
How do you test the reports? Explain the Unit testing procedures after developing the reports?
what is crosstab space
Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
-----------Types of Fact Tables?
6 Answers Bank Of America, CTS,
Tell me about Dnamic and Static Dashboards?