Unsuppress Zero is not working in TI Process.

[Paul-TM1]

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.

Code: Select all

ViewSuppressZeroesSet(SourceCube, SourceCubeView, 0 );

Can someone tell me where I am wrong?

Thanks,
Paul.

[burnstripe]

Try this instead

Code: Select all

ViewExtractSkipZeroesSet(Source Cube, SourceCubeView, 0 );

[Alan Kirk]

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:

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.

[Paul-TM1]

Thanks burnstripe and Alan. It worked like a charm.

Thanks,
Paul.