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

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / guest


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

What is Star schema group?

1 Answers   IBM,

difference between boxtype and visiable

1 Answers   IBM,

what is a join? what are the types of joins?

5 Answers   HCL, Satyam,

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,

What is a Datastore in Cognos?

0 Answers  

what is stitch query?

2 Answers   Syntel,

what are typees of dimensions

5 Answers   HCL,

How do I remove the hyperlink from the drill through report?

2 Answers   Misys,

write a query to display to 10 max record from the employee table?

7 Answers   HCL,

why u need to publish the package?

5 Answers   IBM,

How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories