TM1 Forum

Hello Everyone,

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

I have got a below report to develop
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.

Hola!

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

Yes I know. Thanks.

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

kavitha2002 wrote: ↑Thu Sep 26, 2019 6:24 am 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.

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 ?

Wim Gielis wrote: ↑Thu Sep 26, 2019 9:20 am 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.

In what client(s) should it work ?

It should work in excel (TM1 Perspectives).

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.

Thanks for reply and suggestion.

Steve Rowe wrote: ↑Thu Oct 03, 2019 4:06 pm 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.