Search found 243 matches

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: 1851

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: 4538

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: 1637

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: 1510

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: 720

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: 15072

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: 912

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: 828

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: 15072

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: 662

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...
by Paul Segal
Tue Nov 24, 2015 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Authentication/security Tm1 applications W/O BI
Replies: 19
Views: 3633

Re: Authentication/security Tm1 applications W/O BI

Hi David,

All of BI, or just the admin bit as lotsaram suggests? I mean, just to be clear ;)
by Paul Segal
Tue Nov 03, 2015 9:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insight 2015
Replies: 12
Views: 2439

Re: Insight 2015

Convert to values is good... but bulk paste would be better.
According to what I saw at the London Cubewise conference I think they have the bulk paste sorted as well.
by Paul Segal
Mon Nov 02, 2015 4:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User reporting Unable to open the saved private views.
Replies: 13
Views: 1054

Re: User reporting Unable to open the saved private views.

So, what happens when you create that view, make it public, and the user tries to open the public version?
by Paul Segal
Mon Nov 02, 2015 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User reporting Unable to open the saved private views.
Replies: 13
Views: 1054

Re: User reporting Unable to open the saved private views.

As Wim said. it doesn't matter how much memory the user has on his PC, it's the memory on the server (where the calc is being done) that matters. To echo Wim: either change the MaximumViewSize or educate the user not to attempt to pull down such a large view or figure out why that view is causing pr...
by Paul Segal
Tue Oct 20, 2015 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Renaming a TM1 Service
Replies: 3
Views: 600

Re: Renaming a TM1 Service

I think you're making life too complicated for yourself (and, in the future, others). It's not like it's overly difficult or time consuming to delete the Planning Service service and put a new one up.
by Paul Segal
Tue Oct 13, 2015 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI that finds parent of parent of parent of parent and moves it
Replies: 5
Views: 596

Re: TI that finds parent of parent of parent of parent and moves it

Well, Bedrock is a) free and would b) give you some clues as to how to do what you want to do, even if you don't use the Bedrock code.
by Paul Segal
Thu Oct 08, 2015 8:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Data Server services Down suddenly - Dont know why
Replies: 2
Views: 537

Re: TM1 Data Server services Down suddenly - Dont know why

What does the end of your tm1server.log file say? Is there sufficient disk space for the save? Have you checked the Windows event logs?