Monday, December 19, 2011

Hiding Left-Most Crosstab Columns

How do you hide left-most columns in a crosstab without impacting the alignment of other objects on the crosstab?

You may ask, why would anyone want to hide columns in the first place when you have the "Properties" property? That's because for some reason on 10.1.1 this doesn't seem to be working under certain scenarios. May be because there are prompt macros in the data items I want to use for drill throughs even though I don't want them on the layout. I had even set them on all possible edges. Once I have this figured out with IBM, I will update on why the Properties property isn't working.

Latest update from IBM on why the "Properties" property is not working in a crosstab against a cube in 10.1.1 is possibly because of a defect.

So as a work-around, I had to pull in the columns and hide them.

Properties that you need to set to hide the columns:

Background Color : White

Foreground Color : White

Font : 0px

Size & Overflow : 0px

Border : 1 pt None Black

Padding : 0px 0px 0px 0px

The only down-side is that when exported to excel you will see 2 empty columns to the left of the crosstab object.


Ed said...

I've lost count of the number of times I've not been able to find an answer on the ibm knowledgebase, or cognoise, or itToolbox, or wherever, and I nearly give up hope...but then, one more google and there it is: COGNOS AND ME, gleaming with the diamonds of knowledge and pearls of wisdom. Thanks, man. It's much appreciated.

Zephyr said...

Thank you all for your kind words.

Anonymous said...

I have a requirement not exactly like the above scenario but based on show/hide or conditional rendering of cross tab measures.

I have a cross tab:
Dimension: Say A
Top Label: B
Measures: C, D, E, F

I need to conditionally render the C, D, E and F based on the values in a prompt I created. I was able to create it for a single value say either show C or D or E or F based on the value chosed in the prompt using the prompt token method.

Eg: Measure=#prompt('Parameter Name','token',' Default value to be shown')#.

This works fantastic for a single selection. But my requirement is multi-select values C, D , E and F. The problem is with the top label formatting. Any ideas.

Anonymous said...

Live can be so easy ... thanks a lot for that posting !!

Robert P. Calfee said...

I am William..I just browsing through some blogs and came across yours! Excellent blog, good to see someone actually uses for quality posts.Your site kept me on for a few minutes unlike the rest :)Keep up the good work!Thanks for sharing a important information on cognos

emily said...

Iam very much interest to take training on online coaching.and the course about pega..for this i recommended you to this.

the best pega Online Training training

Saravana Kumar E said...

That was really helpful.. Thank you

Big IT Trainings said...

Microsoft Azure is a cloud computing platform and infrastructure,created by microsoft,for building deploying and managing applications and services through a global network .Azure Online Training
AWS Online TrainingThese services are provided by a Microsoft Azure are PAAS and LAAS .Many programming languages and frameworks are supported by azure cloud comuting services.

lee woo said...

No one can lie, no one can hide anything, when he looks directly into someone's eyes. See the link below for more info.