Is it possible to suppress rows with "--" in a crosstab ?

[oscarca]

Hello Cognoise community,

I was wondering if it is possible to suppress rows that are populated with "--" character. When you apply cell data security on a measure in SSAS all the rows will display as "--" in Cognos Analytics, which messes with the suppression of empty cells. Or if you can change the default character in SSAS.

Best regards,
Oscarca

[magicianer]

Is this from a calculated measure or this is happening with missing values?

[oscarca]

Normal measure from the cube and "--" character is because of security setting on the measure.