How to edit and customize the VBA code into an Action Button on TM1 Perspectives - Excel

[jjramirez]

Hi EveryBody!

My name is Jose José Ramirez (jjramirez) and i start to work with Tm1 a few weeks ago.

Now, i'm trying to build a TM1 websheet to execute some TurboIntegrator Processes using The ActionButton provided by TM1-Perspectives. Each TI-Process has its own parameters, but i need to evaluate some aditional conditions before to start the proccess. For example: my proccesses are in a defined secuence and i want to evaluate that the process 1 is completed before start the process 2. And i want the ActiuonButton Color change after excecuted. In this simple way i think the external user will be pretty sure about the secuence of actions they are executing.

at somewhere in TM1 guides i read that we can edit the ActionButton VBA code so i was thinking to add some code lines to achive what i want, but when i am in VBA editor i can´t see the code asociated to the button.

is there any sense in what i am trying to do? exists a better or easier way? where i can find more information about vba for tm1. I was reading TM1 reference guide but it´s more about predefined macros and i want to do my owns.


Thanks!
Jose José

[tomok]

To the best of my knowledge you cannot alter the VBA inside an Action Button. I think you may be confusing the macro commands available inside Excel through the Perspectives add-in, which would not be what you want since any VBA you do will not execute in TM1Web.

As to your original goal of making sure processes are run in sequence what I would do is create a cube to store the status of the processes (you can even use the }Processes dimension) and in the epilog of each process write out your status. You can then have a DBRW formula on the web sheet that pulls in this status and with conditional formatting make it green or red, or whatever to let the user know. You should also include a CellGetS against this status (or pass it in as a parameter) in the prolog of the successive process to stop execution of the condition is not met. There are lot of options to accomplish what you want, my suggestion is but one way. However, VBA is not one of the options if you want it to work in TM1Web.

[jjramirez]

Good morning Tomok
Thank you very much for your recomendations i´ll be working these days on that.