Active Form Slowness

[George Regateiro]

Are there any best practices to making the column headers of an active form more dynamic? I have been working on a active form that intially takes 2 seconds to rebuild. After adding in some if logic to the form to make the time span (column header) more dynamic the sheet takes 10 seconds to refresh. With each additional element that I have set through if statements the rebuiild time grows exponentially. It is to the point that it takes about 2 minutes to rebuild. I have tried various methods, even moving the logic to a different sheet and nothing seems to help out. In comparison the same sheet through a slice (all the same logic for the columns) takes 8 seconds. Any ideas on what else I could try, I would love to use the active to rid myself of some action buttons.

[lotsaram]

Hi George

Have you tried linking only a single column of your report to the TM1RptView and setting up a standard View formula for the remaining ("dynamic") columns? Possibly this might give better performance, it is worth doing the experiment in any case ...

[George Regateiro]

Thanks for the help your suggestion worked great.