TM1 Forum

I've been hiding under a 10.2.2 rock now for several years so my apologies on getting so late to the party

My client is finally upgrading to PA but we are sticking with on prem and will continue to use Perspectives for the near future
The user community uses TM1 Tools 32 bit extensively with much success

I've been searching the Forum to see if a 64 bit version was ever completed
There was a post from someone that had modified the code and created a TM1Tools.xlam file
I downloaded this as an option but unfortunately it's not working in Microsoft Office 365 64 bit which will be used as the standard Excel interface going forward

Alan, Martin, and Steve, can you please enlighten me?
If there isn't a 64 bit version that works in Microsoft 365 can you suggest an alternative?

All the best,

Solanna

Considering that is a Revelwood tool, and not something from IBM, you should probably contact them.

tomok wrote: ↑Wed Jan 31, 2024 8:47 pm Considering that is a Revelwood tool, and not something from IBM, you should probably contact them.

Ex-fricking-SCUSE me??? I wrote the majority of TM1 Tools, with Steve Rowe and Martin Ryan writing the rest of it (as was alluded to in the original post), and we are not now, and never have been Revelwood.

In response to the original question, I have a new user base which is entirely on 64 bit Excel and some of them are pining for TM1 Tools so yes, I am working on a 64 bit version but I'm looking at converting over to the Rest API since some of the functionality in the existing one is based on ye olde classic API which doesn't support things such as alternative hierarchies. I don't have a timeline on this unfortunately but I'm intermittently working on it at the moment.

Alan Kirk wrote: ↑Wed Jan 31, 2024 9:31 pmIn response to the original question, I have a new user base which is entirely on 64 bit Excel and some of them are pining for TM1 Tools so yes, I am working on a 64 bit version but I'm looking at converting over to the Rest API since some of the functionality in the existing one is based on ye olde classic API which doesn't support things such as alternative hierarchies. I don't have a timeline on this unfortunately but I'm intermittently working on it at the moment.

Not sure if ‘Paste values’ is one of the options in the tools ? I don’t remember.
If yes, it can now be done in PAfE, so might be less relevant then.

Wim Gielis wrote: ↑Wed Jan 31, 2024 10:36 pm

Alan Kirk wrote: ↑Wed Jan 31, 2024 9:31 pmIn response to the original question, I have a new user base which is entirely on 64 bit Excel and some of them are pining for TM1 Tools so yes, I am working on a 64 bit version but I'm looking at converting over to the Rest API since some of the functionality in the existing one is based on ye olde classic API which doesn't support things such as alternative hierarchies. I don't have a timeline on this unfortunately but I'm intermittently working on it at the moment.

Not sure if ‘Paste values’ is one of the options in the tools ? I don’t remember.

It is, and it's one of the principal reasons that the thing needs to be updated to 64 bit because I had to make calls to the Win32 API to access the Windows clipboard.

Wim Gielis wrote: ↑Wed Jan 31, 2024 10:36 pm If yes, it can now be done in PAfE, so might be less relevant then.

It's relevant to those of use who will only allow PAfE onto our sites when Hell freezes over and has a temperature of −274.15 degrees C (sic). Though admittedly when it's time to kiss Perspectives goodbye we'll be doing it with Cubewise Slice, which does also have that functionality. There are a few things preventing us from doing that just yet, but it's light years better than the IBM hunk'o'junk, which I simply will not countenance the presence of.

Alan Kirk wrote: ↑Wed Jan 31, 2024 9:31 pm Ex-fricking-SCUSE me??? I wrote the majority of TM1 Tools, with Steve Rowe and Martin Ryan writing the rest of it (as was alluded to in the original post), and we are not now, and never have been Revelwood.

TOO FUNNY!

Yes, Revelwood did have a "TOOLKIT" and probably still does...
But it's not TM1 Tools

Alan, thanks for verifying my assumption that TM1 Tools 64 bit hasn't been developed yet
Any suggestions on a short term replacement?
If not, I guess they can go "old school" and simply Paste Values

The User Community only uses the "Clear TM1 Formulas" function
For Tom's sake that's the "ZAP" function in the Revelwood offering

Alan Kirk wrote: ↑Wed Jan 31, 2024 11:43 pm It is to those of use who will only allow PAfE onto our sites when Hell freezes over and has a temperature of −274.15 degrees C (sic).

Alan, my sentiments exactly!

Wim, the users are still going to use Perspectives for a while so PAfE is way off in the distance

RBSolanna wrote: ↑Wed Jan 31, 2024 11:59 pm

Alan Kirk wrote: ↑Wed Jan 31, 2024 9:31 pm Ex-fricking-SCUSE me??? I wrote the majority of TM1 Tools, with Steve Rowe and Martin Ryan writing the rest of it (as was alluded to in the original post), and we are not now, and never have been Revelwood.

TOO FUNNY!

Yes, Revelwood did have a "TOOLKIT" and probably still does...
But it's not TM1 Tools

Alan, thanks for verifying my assumption that TM1 Tools 64 bit hasn't been developed yet
Any suggestions on a short term replacement?

I'll test out my development copy and see whether it's viable over the next few days and if it is I'll put it up next week. It has a couple of extra minor features, a couple of minor bug fixes but doesn't include any of the new API or hierarchy stuff yet, but it should get you (and some of my users) what they need in the short term.

Alan,

Thanks and much appreciated!

Solanna