Discontinous Crosstab

[madraj]

Hi,
Can anyone tell what is Discontinous Crosstab?
This is related to Cognos ReportNet.
Thanks in advance.
madraj

 

[JeannetteC]

A crosstab that the rows or columns come from different groupings or are filtered differently.

So you would (generally) have a common theme in the rows (say product group.
And unrelated columns, say Dates (perhaps months or quarters) and type of order.

The crosstab does not have a summary column or row in this case.
HTH
Jeannette

 

[madraj]

Thanks JeanetteC, for the reply. But i am now confused about the two answers you have given.
i.e,. rows or columns come from different groupings or are filtered differently.
Is it possible that these two can be possible?

Thanks
madraj

 

[JeannetteC]

Hi,

Perhaps I didn't explain very well, I will try again.

Let's say that we are looking at orders. We have a manager who would like to see the breakdown of orders for the product groups (I will work with the Great Outdoors theme if you are failiar with it as the Cognos sample database).
He would like to see how the product groups performed in terms of dates (quarters) and order type.

So the crosstab would look like this
Q1 Q2 Q3 Q4 Telephone Fax Email Edi
Camping Eqipment
Mountaineering
Golf
Accessories

So the colums are disimilar information.

Essentially, the two sections of columns are two seperate queries, which you stick together using "union" - so you could have different filters applied at that level.

Does that make any better sense?

Hope so!
Jeannette