Discontinious crosstabs

[dech008]

Hi Everyone,

I have a old question which has already been answered but i have some doubts.
I understand that when we try to have columns from different dimensions in crosstab we call it discontinuous crosstabs.
now i try to do the same and achieved it successfully.

why this "discontinuous" term even comes into picture. i just needed to drag and drop the items from the tables(different dimensions).
Is it possible in some scenario that simply drag n drop wont give me columns from different dimensions.

Can anybody please explain. (Please pardon me if asking very silly question i am very new to the cognos)

Thanks in advance

[MFGF]

I tend to use the term "discontinuous" when there are multiple (ie more than one) sets of data stacked in rows or columns, and the nesting below one stacked item is different from the nesting below the other.

Here is an example:



There are stacked sets in the rows, and different nesting levels within each stack.

Cheers!

MF.

[navissar]

I'm afraid my view is a tad more cynical than the muppet's.

'Tis but thy name that is my enemy;
Thou art thyself, though not a Montague.
What's Montague? it is nor hand, nor foot,
Nor arm, nor face, nor any other part
Belonging to a man. O, be some other name!
What's in a name? that which we call a rose
By any other name would smell as sweet;

The name, discontinuous crosstab (Also known as disjoint crosstab) is just a fancy name, really; it's something you can say at meetings to make you sound like a professional, much like other terms such as MAT (Moving Annual Total) or "Type 4 slowly changing dimension" (A history dim table connected to a current state dim table) or a "tuple" (A data point, really). It is but lingo. When a doctor says "rhinopharyngitis", does she not know that most of us will call it a "cold"?

The term indicates that the crosstab column contains data from two different non related dimensions. The "usual" crosstab will have dim1 on rows, dim2 on columns, and a measure as slice (In the middle...). The disjoint crosstab will have another dimension in a row, which means the data will be unrelated. There's really nothing more to it. It could come in handy when an analyst turns over a report's design and you go "Gasp! this is a discontinuous crosstab!" - you'll get spelling points for correctly spelling "discontinuous" and it might help you to persuade the analyst to drop the weird request...

[dech008]

Thank you people.........


Quantity Sold |   2011   2012   2013   2014   (Years)
_________    |________________________________
InsuranceTy1 |     23       34     324       45 
InsuranceTy2 |     45     534            54       54
Mutual Fund1 |     435       23         3         4
Mutual Fund2 |         4       32         5         2

Insurance dim and Mutual Fund dim are not related and thus can be called, are forming disjoint crosstab.
please comment if missing anything.