Page 1 of 1

About drill through Suppress Zero issue

Posted: Sun Jun 26, 2022 7:48 am
by Niko
I don't know if anyone has seen this before, i have write "ViewExtractSkipZeroesSet (cCubTarget, cViewTarget , 1);" in the custom }drill_process, the driller still sees a view that contains 0

Re: About drill through Suppress Zero issue

Posted: Sun Jun 26, 2022 10:58 am
by gtonkin
Have you tried ViewSuppressZeroesSet ?

Re: About drill through Suppress Zero issue

Posted: Mon Jun 27, 2022 3:52 pm
by Niko
gtonkin wrote: Sun Jun 26, 2022 10:58 am Have you tried ViewSuppressZeroesSet ?
Thank you very much, after i add "ViewSuppressZeroesSet(cCubTarget, cViewTarget , 1);" it works.
And ask another question : what's the difference between "ViewSuppressZeroesSet" and "ViewExtractSkipZeroesSet",
i think they both use to supressZero.
Any help would be greatly appreciated.

Re: About drill through Suppress Zero issue

Posted: Mon Jun 27, 2022 5:30 pm
by gtonkin
ViewSuppressZeroesSet is used to suppress zeroes in views that users would open.
ViewExtractSkipZeroesSet would suppress zeroes in views used in TI as a datasource for processing - may be extracting via Asciioutput, updating same or other cubes etc.

Re: About drill through Suppress Zero issue

Posted: Tue Jun 28, 2022 12:13 pm
by Niko
gtonkin wrote: Mon Jun 27, 2022 5:30 pm ViewSuppressZeroesSet is used to suppress zeroes in views that users would open.
ViewExtractSkipZeroesSet would suppress zeroes in views used in TI as a datasource for processing - may be extracting via Asciioutput, updating same or other cubes etc.
i get it , thank u again