Active form issue with zero suppress

[ravi]

Hi All,

I have active form built with few tabs zero suppress ON (=1) OFF (=0)....
Issue i am facing is Zero suppress should be been hidden on the measures (accounts) when we use cognos tm1 print functionality generating PDF's - PDF show-up Zero- which we don't want. please advise.

Regards,
Ravi

[gtonkin]

As the TM1 Print Report functionality runs off subsets, you want to have your subsets that drive the reporting excludes sites which are zero, rather than suppress zeroes on the Active Form. Use MDX to filter out unwanted elements.

[ravi]

Use MDX to filter out unwanted elements already in place- our MDX is currently pulling accounts list only.
Some of the accounts (numbers) values are Zero- we have written macro hide accounts having zero's -but when use the print functionality of tm1 and generating PDF reports- we see the Zero appear there- which we don't want to show-up.
Any help further..........will be appreciated.

[tomok]

I don't use the Print Report functionality much but I believe your problem is that it only issues a Recalc between selections, not a Rebuild (which is what you need to happen for the zero suppression to remove the unwanted rows).