About drill through Suppress Zero issue

Post Reply
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

About drill through Suppress Zero issue

Post 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
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: About drill through Suppress Zero issue

Post by gtonkin »

Have you tried ViewSuppressZeroesSet ?
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Re: About drill through Suppress Zero issue

Post 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.
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: About drill through Suppress Zero issue

Post 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.
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Re: About drill through Suppress Zero issue

Post 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
Post Reply