Search found 250 matches

by Paul Segal
Fri Apr 28, 2017 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate Time taken for a TM1 server between start and be ready
Replies: 5
Views: 1179

Re: Calculate Time taken for a TM1 server between start and be ready

Powershell is your friend here: start the TM1 service using a powershell script which writes a time-stamp to a file, then performs a start-service on your tm1server. Once the server is up read the file with the time-stamp into TM1 as part of the startup chore as outlined by Tom and you have your ans...
by Paul Segal
Wed Apr 26, 2017 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: cool TI Editor - where to buy?
Replies: 5
Views: 1324

Re: cool TI Editor - where to buy?

Give Cubewise a call - they're normally quite receptive to people wanting to spend money with them.
by Paul Segal
Mon Apr 24, 2017 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 1915

Re: Sublime Text TM1 syntax highlighter

Did you install RegReplace? This is required for the convert bit to work.
by Paul Segal
Mon Apr 24, 2017 6:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 1915

Re: Sublime Text TM1 syntax highlighter

This will be in your user directory settings, so for me this is c:\users\psegal\appdata\roaming\sublime text 3\packages\user. Obviously you need to change as appropriate for your username etc.
by Paul Segal
Mon Apr 10, 2017 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6 IF1 crashing without log entries
Replies: 10
Views: 2026

Re: TM1 10.2.2 FP6 IF1 crashing without log entries

Presumably you've checked available disk space?
by Paul Segal
Mon Feb 27, 2017 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Redesigning
Replies: 10
Views: 2169

Re: TM1 Process Redesigning

You're going to have to give a lot more detail, and also ensure your question adheres to the guidelines http://www.tm1forum.com/viewtopic.php?f=3&t=1037

29 sounds like a lot, but it really rather depends on what your loads are doing.
by Paul Segal
Fri Feb 03, 2017 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To use or not to use persistent feeders?
Replies: 20
Views: 5621

Re: To use or not to use persistent feeders?

+1 for Tom. I have people using the system around the clock, and minimising downtime is key.
by Paul Segal
Tue Jan 31, 2017 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Crashes
Replies: 14
Views: 2133

Re: TM1 Crashes

What happens when you revert to the previous parameters? Are you monitoring memory usage? Anything in the log files?
by Paul Segal
Wed Nov 23, 2016 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Licensing Questions
Replies: 4
Views: 1798

Re: TM1 Licensing Questions

The User licenses enable users to view and manipulate the data etc, and the Server licences are to enable the servers to run, so I'm afraid the answer is yes, you do need both. It would be nice if you didn't...
by Paul Segal
Tue Oct 18, 2016 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Licensing
Replies: 3
Views: 861

Re: Licensing

You're using one licence to create some Excel reports and then sending them out. There's no need for the recipients to use a TM1 licence. I don't see a licence issue here - why do you think there is one?
by Paul Segal
Mon Oct 17, 2016 6:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.3 - IBM Planning Analytics
Replies: 40
Views: 16444

Re: TM1 10.3 - IBM Planning Analytics

I was at an IBM workshop the other week where the presenters were pretty sure of November as the On Premise release. Normal caveats apply.
by Paul Segal
Thu Jul 21, 2016 10:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA Rebuild Current Book
Replies: 4
Views: 1079

Re: VBA Rebuild Current Book

Try Application.Run "TM1REFRESH" rather than "TM1RECALC". Also, the search box above is your friend.
by Paul Segal
Mon Jul 04, 2016 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help with SUBDEFINE. Could not find anything that was solved. Please help.
Replies: 5
Views: 898

Re: Need help with SUBDEFINE. Could not find anything that was solved. Please help.

Try replacing "A1:A10" with

Code: Select all

Worksheets("Worksheetname").Range("A1:A10")
The whole thing should read

Code: Select all

 x = Application.Run("SUBDEFINE", "dev1.dev.boa.com:HeadCount", "testVBss", Worksheets("Worksheetname".Range("A1:10"))
Obviously, replace Worksheetname with the name of your worksheet.
by Paul Segal
Mon Mar 14, 2016 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.3 - IBM Planning Analytics
Replies: 40
Views: 16444

Re: TM1 10.3 - IBM Planning Analytics

I heard Q3 is the current target for on premise release. Of course, that might slip ;)
by Paul Segal
Mon Mar 14, 2016 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Send encrypted email out of TI
Replies: 4
Views: 759

Re: Send encrypted email out of TI

One solution would be to write the email to text on the TM1 Server and have some VBA in an Outlook instance which looped round any text files in the directory and used the text to send the email. The advantage here is that you are just using VBA and Outlook's built-in encryption. The disadvantage is...