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

Cognos 8.2. Crosstab

Started by Wild Klaus, 01 Aug 2008 03:19:25 AM

Previous topic - Next topic

Wild Klaus

Hello!

I have such problem (cognos 8.2, Report Studio):



I have a crosstab like this



              date1                    date2                  ... dateN
        value1  comment1    value2  comment2      valueN commentN
-----------------------------------------------------------------

attrA  Avalue1 Acomment1  Avalue2 Acomment2 ...AvalueN AcommentN

attrB  Bvalue1 Bcomment1   Bvalue2 Bcomment2 ...BvalueN BcommentN

....

attrN  Nvalue1 Ncomment1  Nvalue2 Ncomment2 ...NvalueN NcommentN





and I need to add a column to it.



Column should be like this:



                                   Acomment1

                                   Acomment2

for attrA -                     Acomment3...

                                   ...

                                   AcommentN

                       





                                   Bcomment1

                                   Bcomment2

for attrB -                     Bcomment...

                                   ...

                                   BcommentN

                                   



and so on.





Thus I need to add a column to the crosstab, which cells have to contain all values from other cells of the corresponding

crosstab row and these values should be in the table form.



How can I do this?



Any help is appreciated!


rockytopmark

Insert a Crosstab space on the COlumn Edge where you need these other values, then select the interection for the Crosstab Space and the row edges they pertain to.  In the intersection properties, select Yes for the "Define Contents" property.

Insert that query item that pertains to this cell in the intersection's cell.

Your crosstab's row edge properties may need to be set to include the query items that are being added to the content and are not part of the natural edges or intersections of the crosstab.