Active form on the Web in conjunction with zero-set suppression

Post Reply
ConPlan
Posts: 2
Joined: Thu Nov 30, 2017 10:14 am
OLAP Product: TM1
Version: Server 10.2.2 Client 10.1
Excel Version: Excel 2010
Location: Germany

Active form on the Web in conjunction with zero-set suppression

Post by ConPlan » Thu Nov 30, 2017 10:43 am

Hello everybody
currently I am creating a planning form with active forms.
I use the zero suppression to not give the user so many lines.
Then I load the form in TM1 Web.
Sometimes it would be useful to show the lines here again.
On the web, I have no button zero suppression as in Excel.
Which options do I have?
Many thanks for your help

User avatar
tomok
MVP
Posts: 2356
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Active form on the Web in conjunction with zero-set suppression

Post by tomok » Thu Nov 30, 2017 12:19 pm

The TM1RPTVIEW formula has an argument for zero suppression, either 0 or 1. Create a drop-down in cell, with data validation, that accepts either 0 or 1 and point the argument to that cell. User can then select to turn zero suppression on or off with this drop-down.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

ConPlan
Posts: 2
Joined: Thu Nov 30, 2017 10:14 am
OLAP Product: TM1
Version: Server 10.2.2 Client 10.1
Excel Version: Excel 2010
Location: Germany

Re: Active form on the Web in conjunction with zero-set suppression

Post by ConPlan » Thu Nov 30, 2017 1:22 pm

Thank you tomok, for the quick and understandable answer.
You helped me a lot. :D

Post Reply