Page 1 of 1

Active Form with Perspectives

Posted: Mon Aug 20, 2018 3:36 pm
by Willi
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

Re: Active Form with Perspectives

Posted: Mon Aug 20, 2018 4:03 pm
by tomok
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.

Re: Active Form with Perspectives

Posted: Tue Aug 21, 2018 8:41 pm
by Willi
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.