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

Author Topic: Discontinuous Crosstab in Query Studio?  (Read 9519 times)

cognos_guru

  • Guest
Discontinuous Crosstab in Query Studio?
« 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.

Offline Grim

  • Honorary Master of IBM Links
  • Statesman
  • ******
  • Join Date: Nov 2011
  • Posts: 688
  • Forum Citizenship: +58/-7
Re: Discontinuous Crosstab in Query Studio?
« Reply #1 on: 28 Feb 2012 08:56:15 am »
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)

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,544
  • Forum Citizenship: +673/-10
  • Cognos Software Muppet
Re: Discontinuous Crosstab in Query Studio?
« Reply #2 on: 28 Feb 2012 04:58:40 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!

Offline Grim

  • Honorary Master of IBM Links
  • Statesman
  • ******
  • Join Date: Nov 2011
  • Posts: 688
  • Forum Citizenship: +58/-7
Re: Discontinuous Crosstab in Query Studio?
« Reply #3 on: 29 Feb 2012 06:37:26 am »
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

  • Guest
Re: Discontinuous Crosstab in Query Studio?
« Reply #4 on: 24 Jan 2013 10:19:32 am »
Very delayed response on my part, but thanks!