New Active Form Behavior

[tomok]

I’ve recently noticed an issue with Dynamic Reports and how they work compared to how Active Forms used work. I have a ton of forms built using Perspectives that have worked fine until just recently. The issue comes in areas in the workbook where manual modifications were made to the active form. For example, I have reports where the bulk of the data comes from one cube but I need some columns from a different cube or maybe an attribute. I used to be able to just tack on a few extra columns and TM1 would copy formulas on that column down when the form was rebuilt, even though they are not part of the active form that is being re-drawn.

Now, it looks like the formulas in those columns that are not part of the original active form do not copy down from the first row like the rest of the columns inside the original active form. Does anyone know what is up with this and if there is a workaround.

[declanr]

It's not something that I've noticed happening yet. What version of PAFE are you using?

Have you checked the named ranges to make sure they are covering the other columns? I know normally it would just expand to cover everything without intervention but wondering if something has changed where it needs you to tell it.

[tomok]

It's not something that I've noticed happening yet. What version of PAFE are you using?

Have you checked the named ranges to make sure they are covering the other columns? I know normally it would just expand to cover everything without intervention but wondering if something has changed where it needs you to tell it.

The only named range I know that covers columns is the TM1RPTFMTRNG range and I tried that already to no avail. I have a suspicion it has something to do with zero-suppression. When I would turn off zero suppression it would copy down the formulas in the outside columns but I would then end up with a lot of zero rows. Thanks for the idea.

[JohnO]

I’ve recently noticed an issue with Dynamic Reports and how they work compared to how Active Forms used work. I

https://www.ibm.com/docs/en/planning-an ... s-features

Could your problem be the following? ie: Nothing has changed so there is no rebuild of the rows? I've certainly experienced this.

Rebuilding a Dynamic Report

Rebuilding a Dynamic Report only rebuilds the items that were changed in the report, rather than rebuilding all of the items in the report. This allows reports to rebuild faster than in TM1 Perspectives.

[MarenC]

Hi,

The other thing to test, if you haven't already, is to first insert the new columns inside the existing ones, for example insert before the last column, and then if those columns calculate ok, move the last column to before the new columns.

Maren