COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: oscarca on 02 Jun 2020 01:57:13 AM

Title: Is it possible to suppress rows with "--" in a crosstab ?
Post by: oscarca on 02 Jun 2020 01:57:13 AM
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
Title: Re: Is it possible to suppress rows with "--" in a crosstab ?
Post by: magicianer on 03 Jun 2020 12:46:28 PM
Is this from a calculated measure or this is happening with missing values?
Title: Re: Is it possible to suppress rows with "--" in a crosstab ?
Post by: oscarca on 04 Jun 2020 03:51:54 AM
Normal measure from the cube and "--" character is because of security setting on the measure.