About drill through Suppress Zero issue
-
- 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
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
- 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
Have you tried ViewSuppressZeroesSet ?
-
- 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
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.
- 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
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.
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.
-
- 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
i get it , thank u again