Tm1 Action button - call Macro

[kavitha2002]

Hello Everyone,

I have worked on basic TM1 Action button which calls the TI process.

I have got a below report to develop

sample_xlsm.png (3.85 KiB) Viewed 8792 times

but here 'Actuals' is textbox and it calls the macro which in turn call Application.Run "ExecuteActionButton", "2325345". All the menu icons are named as TM1Button. I cant see much info from this report.

Its something like calling the macro which in turn calls the TI process?? How can I develop the report like this? Is it Possible?

Thanks in advance for all who spend time on this.

[HighKeys]

Hola!

As i know u have to use "Action Buttons" from TM1 to trigger TI Processes.

TI Excel.PNG (31.95 KiB) Viewed 8760 times

BR

[kavitha2002]

Yes I know. Thanks.

Is there other possibility of calling the macro via Tm1 Action button?

[orlando]

Yes I know. Thanks.

Is there other possibility of calling the macro via Tm1 Action button?

Nope. I don't think there is any supported way to do so.

[Wim Gielis]

What do you want to do ? Using a shape or textbox instead of an action button, and then the consequence is that you can't easily run TI processes ?

[kavitha2002]

What do you want to do ? Using a shape or textbox instead of an action button, and then the consequence is that you can't easily run TI processes ?

yes, exactly. I would like to make a report with shapes or textboxes and call the TI process via macros. Above I have attached the sample report for reference.

[Wim Gielis]

In what client(s) should it work ?

[kavitha2002]

It should work in excel (TM1 Perspectives).

[Steve Rowe]

If you are using PA for Excel then (your opening posts looks like PA for Excel but later you say Perspectives)

https://ibm.github.io/paxapi/#introduction

If you are using Perspectives then you can write calls using the old API but it is much much more involved. You may find some good material with some googluck but I don't think the code is widely shared due to the level of effort required to produce it.

[kavitha2002]

Thanks for reply and suggestion.

[tomok]

IIf you are using Perspectives then you can write calls using the old API but it is much much more involved. You may find some good material with some googluck but I don't think the code is widely shared due to the level of effort required to produce it.

With all due respect this is a really bad idea if you care about the longevity of your solution. Once IBM kills the old API (and it's happening, only a question of when) then all your work will go down the toilet. Better to look for a solution using PAX action buttons or calling something in the REST API.