If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Discontinuous Crosstab in Query Studio?

Started by cognos_guru, 27 Feb 2012 01:06:26 PM

Previous topic - Next topic

cognos_guru

Hello,

Is it possible to create a discontinuous crosstab in Query Studio?  I can't find any documentation on the topic...

Thanks.

Grim

What do you mean by "Discontinuous xtab"?
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

MFGF

Quote from: cognos_guru on 27 Feb 2012 01:06:26 PM
Hello,

Is it possible to create a discontinuous crosstab in Query Studio?  I can't find any documentation on the topic...

Thanks.

Nope. Stacking is not available in crosstabs in Query Studio - only nesting. You would need to use Report Studio or Analysis Studio for discontinuous crosstabs.

Regards,

MF.

PS - Grim, a discontinuous crosstab is where sets are stacked in rows and/or columns, and the stacked sets have different nested levels to other sets on the same axis, eg a crosstab with Product Types and Order Methods nested in rows, then stacked below these in rows you have Years with nothing else nested alongside.
Meep!

Grim

Quote from: MFGF on 28 Feb 2012 04:58:40 PM
PS - Grim, a discontinuous crosstab is where sets are stacked in rows and/or columns, and the stacked sets have different nested levels to other sets on the same axis, eg a crosstab with Product Types and Order Methods nested in rows, then stacked below these in rows you have Years with nothing else nested alongside.

Thanks.
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

cognos_guru

Very delayed response on my part, but thanks!