TM1 Forum

Hi All,
I have looked for zero suppress in the forum and learnt that when a view is created, zero suppress is set. I am later turning off using the ViewSuppressZeroesSet and it does not work.
Can someone tell me where I am wrong?

Thanks,
Paul.

Try this instead

Paul-TM1 wrote: ↑Thu Nov 21, 2024 8:54 pm Can someone tell me where I am wrong?

Pretty much everywhere, I'm afraid. Let's start with the thread title:

Unsuppress Zero is not working in TI Process

There is no UN-suppress zero. Because:

Paul-TM1 wrote: ↑Thu Nov 21, 2024 8:54 pm I have looked for zero suppress in the forum and learnt that when a view is created, zero suppress is set.

I don't know where you got that from, but the opposite is true. Zeros are not suppressed by default, which has the occasionally painful result of a view returning hundreds of millions of values until the server says "Enough! View memory exceeded!".

You have to explicitly tell TI that you want zeroes suppressed for the view that it has created, and you do that by setting ViewSuppressZeroesSet to 1, not 0 assuming that this is the type of view that an end user will be using in Cube Viewer.

If instead the view is intended as a data source (all rows and columns, no titles) you would be using ViewExtractSkipZeroesSet instead.

If you do actually mean that you DO want zeroes in your data source than you don't HAVE to use those functions since the zeroes will be there regardless... but you should think very carefully about how large that will make your view.

Thanks burnstripe and Alan. It worked like a charm.

Thanks,
Paul.