TM1 Forum

I was wondering when you create a TM1 Action button to run processes. I was wondering since when you enable the VBA Source Code and click on the Action button, you won't see any code. Since I'm still stuck with my problem where I have 4 cubes related to each other and elements from a dimension similar to all 4 needs to be transfered. Since it seems nearly impossible to resolve this issue I was thinking of having the Action button be disabled as a notification to the user that the process was already been done. Just to avoid having the process run and a zero value would override the value that was just transferred.

I'm just worried that if I try to disable it the process behind the action button will be messed up.

try this one
http://forums.olapforums.com/viewtopic. ... 973#p11973

you need to modify the code to meet your needs
you can put a button that execute the macro then put a dummy element, variable / something that indicates the process has been executed

good luck

appleglaze28 wrote:...I was thinking of having the Action button be disabled as a notification to the user that the process was already been done. Just to avoid having the process run and a zero value would override the value that was just transferred.

I'm just worried that if I try to disable it the process behind the action button will be messed up.

Probably the easiest way to achieve this is to have the last of your four chained processes write a value to a control cube to indicate that the process has run. Your first process checks this control cube value and if the process has already run then exit without going any further.

Should achieve what you need quite simply.