Active Form with Perspectives

Post Reply
Willi
Posts: 143
Joined: Mon Oct 07, 2013 11:51 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Active Form with Perspectives

Post by Willi » Mon Aug 20, 2018 3:36 pm

Hi,

I have an active form with 2 Columns created by TM1RPTROW. And (currently) one column responsible for the Zero-Suppression. Than I have a bunch of columns provided by VIEW or DBRA. This works all fine if I disable Zero-Suppression. If I enable it no row is displayed at all. Only the normal empty row.

If I publish the Sheet in TM1Web it works as wanted.

Any ideas or known bugs?

we're using PA 2.0.4

Thx and regards

User avatar
tomok
MVP
Posts: 2498
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 with Perspectives

Post by tomok » Mon Aug 20, 2018 4:03 pm

In order for this to work everything for the zero-suppressed view have to be in contiguous columns. The columns you want to provide via a VIEW statement must be out to the right of the zero-suppressed section of the active form. If you mix them up the zero suppression won't work.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Willi
Posts: 143
Joined: Mon Oct 07, 2013 11:51 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: Active Form with Perspectives

Post by Willi » Tue Aug 21, 2018 8:41 pm

Hi, thx for the hint it doesn't work.

I have the row-format in Col A, Nothing in Col B the 2 TM1RPTROW in C and D and the value for Zero-Supression in E. But if I use it in Excel I don't get a line but should get around 10. If I disable Zero-Supression it works.

Post Reply