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.
Posts
8 comments:
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.
Thank you all for your kind words.
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.
Live can be so easy ... thanks a lot for that posting !!
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
That was really helpful.. Thank you
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.
No one can lie, no one can hide anything, when he looks directly into someone's eyes. See the link below for more info.
#hide
www.ufgop.org
Post a Comment