PAx API v TM1 10.2 VBA

Post Reply
User avatar
Posts: 140
Joined: Wed May 14, 2008 8:27 am
OLAP Product: TM1
Version: 10.2.0
Excel Version: 2016
Location: London

PAx API v TM1 10.2 VBA

Post by Ajay » Sun Oct 27, 2019 11:39 am

We are presently planning our upgrade from TM1 10.2 upto PA 2.0.8

We have four instances that will move up and for three of them we foresee few issues.

However, one of them is a very old legacy instance, heavily VBA based, to the extent that none of the standard TM1 tools, like Server Explorer, subset editor etc aren't even exposed to the end user. The key TM1 functions are run as VBA buttons on a customised Excel toolbar.

IBM have told us that TM1 VBA functions will not work in PAx, and having done some rudimentary testing we can see that normal excel VBA will work but the TM1 related ones don’t.

Even the standard commands below wont action

Application.Run "TM1Refresh"
Application.Run "TM1RECALC1"

Has anyone successfully used the new PAx API commands to do these functions ? and what problems have been encountered using other PAx API commands ?

Are there certain things to watch out for ?

Would we simply copy the following into our VBA where the above commands are, or do we need to do something else:

Reporting.DynamicReports.GetAt().Item(<Dynamic Report ID>).Refresh

Thanks in advance
10.2.0, w2008R2 OS Enterprise Edition, 1TB HD, 384GB RAM, MS Excel 2016, Cognos 10 BI

Post Reply