Automatically Rebuild Active Form Websheets

Post Reply
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Automatically Rebuild Active Form Websheets

Post by cdhodge2002 »

I have a question does anybody know how to automatically update an active form tm1rptrow whenever a title row item is changed?

I currently have my web.config file set up like this per the IBM site I saw online
<!-- Websheet Paging Settings -->
<add key="WebsheetPaging" value="Enabled=true;PageSize=100;PageResetMode=3" />


I have the tm1rptrow using a MDX statement so whenever I update an item in the title area the list will change, however this requires an active form rebuild. My client would like not to rebuild the form everytime they make a change. Again this is over the web.
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Re: Automatically Rebuild Active Form Websheets

Post by cdhodge2002 »

So I am guessing this is not possible?
lotsaram
MVP
Posts: 3683
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Automatically Rebuild Active Form Websheets

Post by lotsaram »

There are some tricks. Try replacing SUBNM title references with DBR strings with picklists. This can force rebuild of the active form as this is the default behavior when a picklist value is changed.

Depending on where you are I think there are some topics on this in the agenda of the Cubewise TM1 conferences later this month.
Post Reply