TM1 Active Form

[gayathri]

Hi,

Need some help with the Active forms.

I have two active forms, once i click on an action button in the first active form,it will make some changes in the dimension elements(it deletes few records) and takes me to the second active form.Now once i come back to the first sheet it is still showing the deleted records.(Its not refreshing the form).We can refresh it by clicking on the'rebuild the current sheet' but my client doesnt want to do that.Neither he wants an action button which rebuilds the sheet.

So is there any way to refresh the sheet without clicking anything.

Thanks in Advance!

[qml]

Go to the Action Button Properties window and change the Calculate option to Rebuild Sheet without changing anything else, then click OK.

[gayathri]

Thanks for your reply!

But ..sorry..in the first active form,its not an action button...it is an excel button,inside which macro has been written which in turn runs a TI process to delete records.

Sorry once again!

Is there any other way to refresh the sheet.

[lotsaram]

Thanks for your reply!

But ..sorry..in the first active form,its not an action button...it is an excel button,inside which macro has been written which in turn runs a TI process to delete records.

Sorry once again!

Is there any other way to refresh the sheet.

If you can write a macro to run a process (not that easy since this requires a whole lot of TM1 API declarations - but I'm assuming you copy and pasted from someone else) then surely you can also read the reference guide documentation "TM1 Macro Functions" and look up the function "TM1REFRESH"? ... Oh no, you can't because despite this function being introduced in 9.4 and the current version being 10.1.1 IBM still hasn't updated the documentation to include this function! .

(Mind you using the macro recorder and pressing Alt+F9 keys to see what gets recorded ain't that difficult either. Nor is a quick search of this forum for "active forms" where you would have found this function referred to countless times I'm sure.)