COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: pcog on 02 Apr 2014 08:45:18 AM

Title: Zero suppression
Post by: pcog on 02 Apr 2014 08:45:18 AM
Hi,

Is it possible to do Zero suppression within the Transformer cube? If yes, can someone please explain?
Title: Re: Zero suppression
Post by: pcog on 04 Apr 2014 02:08:33 PM
Someone please answer to my question?
I don't think Suppression is not an option here. Suppression on a category will completely hide it. But, I'm thinking something like filter a category to get only the not zero values.
Is it possible to filter one of the category?

Please someone reply.
Title: Re: Zero suppression
Post by: Lynn on 07 Apr 2014 08:09:13 AM
I think what you are describing would be done on the reporting side or by not including zero values in your feed to the cube. If you don't feed zero values into the cube build from your source it isn't going to create zeros. There would be null values at any of these intersections as far as I understand it.