Minimum width of column cannot be set to 0 in a crosstab

[former_member486909]

Hi All,

I want to hide the last column (which is a measure) in a crosstab. As this is not a dimension, it cannot be set to MEMBER -> NO_DISPLAY. Thus, am making the width of this column as 0, but there is a minimum width and 0 cannot be set. As a result, a thin white line is appearing which is not acceptable to users, especially in the pink background of the dashboard. Is there a way, I can get rid of this thin white line?

Would be highly obliged for any kind of suggestion.

Thanks in advance

Swasti

[MustafaBensan]

Hi Swasti,

Why don't you simply remove the measure in the Initial View Editor of the data source? This way it will not be displayed in the Crosstab.

Regards,

Mustafa.

[former_member486909]

Hi Mustafa,

This is because I am trying to achieve a roundabout solution to alerts in crosstabs (backend is HANA). In order to do that, am using textboxes, instead of crosstab and my data should appear in a particular ranked order. To overcome limitation of GetDataAsString, am using alias data sources-1 which has the dimension, rank and measure and 2 which has rank and measure. From 1st datasource, I am displaying rank (hide it then) and dimension in a crosstab while from 2nd datasource I am displaying measure (which has alerts) in textboxes. Thus, I need to hide the measure coming from the 1st datasource, in the crosstab. I am able to achieve the alert functionality (it will look like 1 crosstab but actually its 1 crosstab and all text boxes) using this solution.

However, a thin white line appears when making the column width 0 for the measure in the crosstab coming from 1st datasource. We have issues with Analysis for Office, thereby, not applying the Smart copy, smart paste solution.

Regards,

Swasti

[MustafaBensan]

Hi Swasti,

In that case you can try applying the technique described in the following blog:

https://blogs.sap.com/2014/07/28/sap-design-studio-showinghiding-crosstab-columns-with-measures-with...

Regards,

Mustafa.

[former_member486909]

Many thanks for this useful post Mustafa!

However, my client will not go for the solution of checkbox or radio box as in this case. They are not bothered of how the functionality is achieved, as long as it is as per their expectations. But they will not compromise on the look and feel of the dashboard. In my solution, the thin white line is conflicting with the dashboard's look and feel 😞

Request you to ponder further on this and is possible please let me know how I can get rid of the white line!

Regards,

Swasti

[MustafaBensan]

Swasti,

You have taken the referenced post too literally. The point of referring you to the post was so you can understand how to create the appropriate CSS for hiding columns. In the examples in the post, the check boxes and radio buttons are for demonstrative purposes only. In your case, you can just apply the appropriate CSS via scripting or by setting the CSS Class property of the Crosstab, to hide the relevant columns.

Regards,

Mustafa.