Perspectives Active Form generating duplicate sections

Post Reply
JohnO
Posts: 97
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.9.x
Excel Version: Office 365 16

Perspectives Active Form generating duplicate sections

Post by JohnO »

We have just moved from 2.0.6 to 2.0.9.15 local. Win 2019, Office 365 On the server we are keeping Perspectives in order to use the Print Report function.

There have been no changes to the report templates. When we use either the previous version from a laptop or the newer version (dated last year - cannot find any perspectives version release info) the following happens on rebuild.

Active form data area rebuilds fine but another section is created below it with a duplicate of the same rows in the data range except the row that contains TM1RPTROW. In some cases we get 2 extra sections.

I delete all of the offending rows from multiple active forms, perform a rebuild and it happens again.

Suggestions welcome
User avatar
gtonkin
MVP
Posts: 1203
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Perspectives Active Form generating duplicate sections

Post by gtonkin »

After deleting all rows below the TM1RPTROW, have you tried removing the named range referring to the DATARNG? This should be regenerated on rebuild.
Post Reply