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
Active Form with Perspectives
-
- MVP
- Posts: 2832
- 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
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.
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Active Form with Perspectives
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.
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.