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

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

Question Posted / guest

1 Answers
5343 Views
HCL, I also Faced
E-Mail Answers

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 Online View?

0 Answers IBM,

What is the use of Cognos scenario?

0 Answers

How to a create header dynamically in a crosstab report in cognos 8.1?

0 Answers

What is the difference between List and Cross tab? Could some on explain with an example..

2 Answers Barclays,

what is bobble chart?

1 Answers Syntel,

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers HCL,

After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?

1 Answers

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

1 Answers HCL,

---------------What is meant by Scheduling?

2 Answers IBM,

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers IBM,

Can you explain new content durability?

0 Answers

hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance

26 Answers IBM,

For more Cognos Interview Questions Click Here