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

Hiding nested column in Crosstab

Started by Cognos_World, 10 Apr 2012 11:21:46 AM

Previous topic - Next topic

Cognos_World

Hello Gurus,

I wanted to hide a nested column in a crosstab. Box Type doesn't solve the problem. Render variable is not available for the croostab node member.
Box type = None, hides the nested column but the column in which it is nested that does not get adjusted based on the hidden columns, so the nested columns from the other column gets squeezed and the readability of the report is lost.


E.g.

              A            B          C
          A1  A2   B1   B2   C1  C2
ABC
DEF
GHI

After box type = none, (for columns A2, B2, C2) formatting gets messed up and becomes unreadable.

              A          B       C
        A1    B1    C1

ABC
DEF
GHI

Desired result

            A           B         C
          A1          B1       C1
ABC
DEF
GHI

Tried conditional variable but that has also not helped to get the desired result.

Thanks












SynexusStuart

Are you trying to hide the title or the whole column?

If you're trying to hide the whole column, what purpose is it serving in the report?

Stuart

Cognos_World

Those columns provide the % Total calculation for A1, B1, C1.
If I cut the columns A2, B2 and C2 then then my Summary % Total for A1, B1 and C1 is coming blank.

The summary % Total is a calculated item. After doing the Define Content = Yes and unlocking the report, I have inserted this summary calculation in the total line. I gave a higher solve order. I was expecting this will give me the correct % Total for A1 column and A2 can be the % Total summary.
Because this gave the Summary % Total blank, I introduced this column A2 in the report layout. This gave me the % Total at the summary level correctly.
I tried to get rid of this extra column by cutting the column, using box type = none, but this is making the summary % Total blank again.

Desired result

                A           B         C
               A1          B1       C1
ABC        xx%       y.y%    z.z%
DEF        xx%       y.y%    z.z%
GHI        xx%       y.y%    z.z%
Total       A2          B2        C2

Thanks,

wyconian

Hi

I think you're doing the right thing in changing the box type to none.  The problem is taht other columns get moved across.  To get over this try adding a crosstab space where the column you've hidden used to be.  That should lien everything back up again.  You may need to use a crosstab space with fact cells if yiou get issues with the calculations not being populated.