Zero Suppress on Pages for Excel Report Printing

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Zero Suppress on Pages for Excel Report Printing

Post by mce »

Hi,
When using print report feature in Perspectives, is it possible to suppress zero pages while generating/printing multiple sheet reports?
Regards,
Top
Shelly
Posts: 1
Joined: Thu Nov 06, 2014 10:46 pm
OLAP Product: Cognos
Version: 10.2
Excel Version: 2013

Re: Zero Suppress on Pages for Excel Report Printing

Post by Shelly »

Was a solution to this ever found? I have the same need.
Thanks
Top
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:
Contact declanr

Re: Zero Suppress on Pages for Excel Report Printing

Post by declanr »

Just make the subset in the relevant SUBNM formula an MDX expression filtered on whether there are values found in the intersection being printed.
Declan Rodger
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”