Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


hi Cognos Experts Pls Expalin me what is the diffence
between list report query and crosstab report query?pls
explain me.....



hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report..

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

Post New Answer

More Cognos Interview Questions

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,


What do you understand by the term 'aggregate advisor?'

0 Answers  


Can u please describe the different types of traps with eg. Thanks

2 Answers  


-------------Diff b/w Union and Unionall?

3 Answers   Cap Gemini,


using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  


How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,


what is crosstab space

1 Answers   IBM,


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

2 Answers  


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

2 Answers  


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..

0 Answers  


-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,


Tell me about Dnamic and Static Dashboards?

0 Answers  


Categories