Search found 65 matches

by TJMurphy
Wed Feb 27, 2019 8:34 pm
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 12149

Re: Clear TM1 Formulae from Excel

As promised, reporting back. Using a usedrange.value = usedrange.value approach has given me a fast enough zap to work with this model. It's still not as quick as I'd expect (given the size of the model but that kind of fits in with my idea that Excel was trying to redraw all the graphs in the middl...
by TJMurphy
Mon Feb 25, 2019 10:53 am
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 12149

Re: Clear TM1 Formulae from Excel

Thanks, that's an idea I hadn't thought about. Given the relatively small numbers of TM1 formulae I was stuck on optimising zapping them. I did have one other "alternate" idea - I put the entire report up on TM1 Web and took a snapshot from there. That gave very fast performance and was going to be ...
by TJMurphy
Sun Feb 24, 2019 11:37 am
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 12149

Re: Clear TM1 Formulae from Excel

Has anyone experienced certain models that work much slower to "zap" than others? We've got an add-in with home-grown VBA code that removes all the TM1 formulae in a model. In terms of logic and flow it's actually very similar to the previous ones shared here. It works fine on nearly all of our mode...
by TJMurphy
Sat Dec 08, 2018 10:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 11
Views: 741

Re: Dropdown list in Chrome for TM1 Web not responding

It's not just you. Our PCs are built by our IT folks and so allegedly have a standard image / build. We've got users who can use TM1 Web in Chrome, we've got some who can log in but who can't do make any of the drop-downs and we've got users who get the splash screen promptly followed by an error m...
by TJMurphy
Sun Aug 12, 2018 10:10 am
Forum: Bugs
Topic: Can't convert DBRW to DBSW
Replies: 4
Views: 1533

Re: Can't convert DBRW to DBSW

Hi, we do not see this behaviour on 10.2.2 FP5 on Excel 2016 in our environment. Would be a royal pain as we use it this way a lot.
by TJMurphy
Fri Aug 03, 2018 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 11
Views: 741

Re: Dropdown list in Chrome for TM1 Web not responding

It's not just you. Our PCs are built by our IT folks and so allegedly have a standard image / build. We've got users who can use TM1 Web in Chrome, we've got some who can log in but who can't do make any of the drop-downs and we've got users who get the splash screen promptly followed by an error me...
by TJMurphy
Sat Jul 21, 2018 9:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Older Perspectives, Newer Server - Specifically 10.2.2 and 2.04
Replies: 2
Views: 1021

Re: Older Perspectives, Newer Server - Specifically 10.2.2 and 2.04

Thank you Paul, my searching hadn't turned that one up - my bad.
by TJMurphy
Sat Jul 14, 2018 9:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Older Perspectives, Newer Server - Specifically 10.2.2 and 2.04
Replies: 2
Views: 1021

Older Perspectives, Newer Server - Specifically 10.2.2 and 2.04

Hi all I know this has come up a number of times so I've done the usual stuff (set ClientVersionMinimum and Support older TLS client setting) but has anyone got this combination working ... We're trying to get older clients (10.2.2 FP5) working with a newer server (Planning Analytics 2.0.4). The rea...
by TJMurphy
Sat Jan 13, 2018 11:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web showing Bold
Replies: 4
Views: 871

Re: TM1 Web showing Bold

If it's not a formatting problem then I wonder if it's http://www.ibm.com/support/docview.wss?uid=swg1PI91427&myns=swgimgmt&mynp=OCSS9RXT&mync=R&cm_sp=swgimgmt-_-OCSS9RXT-_-R ? The heading is : PI91427: TM1 WEB SHOWS IN BOLD SOME LINES OF A WEBSHEET WHILE IN PERSPECTIVES THOSE LINES ARE NOT IN BOLD ...
by TJMurphy
Mon Aug 28, 2017 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA Macro errors in Excel 2016
Replies: 17
Views: 3821

Re: VBA Macro errors in Excel 2016

And another thing we had to do was to make sure with all the buttons that we set the property "TakeFocusOnClick" to false. We've definitely found Excel 2016 somewhat more "sensitive" shall we say about where it thinks it is and we find we need to be uber-specific about where things are.
by TJMurphy
Sun Nov 29, 2015 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rep and Sync
Replies: 5
Views: 1382

Re: TM1 Rep and Sync

Thanks for the push to FP4. We'd been sitting on it but have actually just scheduled it for this week now.

Have not been having the problems with FP2 anyway to be honest - fingers crossed for it's last week!
by TJMurphy
Sun Nov 22, 2015 4:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rep and Sync
Replies: 5
Views: 1382

Re: TM1 Rep and Sync

We're using it successfully and have been since 9.5.1 and now on 10.2.2 FP2. However, we've a simple system, all data goes into one box and is synched to the other one which is to all intents and purposes a read-only site in another territory. It gives us a (warm) backup and speeds up access for the...
by TJMurphy
Sun Nov 08, 2015 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New bhaviour (focus related) with Application Folder files
Replies: 2
Views: 647

Re: New bhaviour (focus related) with Application Folder files

Just in case anyone thought I was smoking something odd, we've had our TM1 consultants look at this and they agreed it was something wrong. We explored the files in different formats, xls, xlsx and xlsm, launching from both application folders and file opens. So, it's been logged with IBM for invest...
by TJMurphy
Sun Oct 18, 2015 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New bhaviour (focus related) with Application Folder files
Replies: 2
Views: 647

New bhaviour (focus related) with Application Folder files

Hi all Wondering if this rings any bells with anyone ... I'm leaning towards my question being "has there been any recent Microsoft patches to Windows 7 / Office 2013 that have changed VBA behaviour?" We've upgraded to 10.2.2 FP2 from 9.5.1 recently. We had a number of models in our Application Fold...
by TJMurphy
Sun Oct 11, 2015 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 201510_201511 - Do you plan to use CAFE as a replacement or supplement for Client and Why?
Replies: 7
Views: 2289

Re: Monthly Poll 201510 - Do you plan to use CAFE as a replacement or supplement for Client and Why?

All three of them, more's the pity. * Cafe for people in far flung places with terrible speed over the WAN, if we can get it working then we should be able to decommission replication too. Challenge is finding time / resource to help users update their reports - testing so far with using Cafe on nat...
by TJMurphy
Sun Aug 09, 2015 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does more RAM slow down server start times?
Replies: 5
Views: 1872

Re: Does more RAM slow down server start times?

Hi, update for you all, thanks for looking. We have now established we do indeed have a production server with slower cores than our staging server. We did some calculations based on IBM's PVUs and the timing differences in the log files so that all seems to stack up. My original concern was that th...
by TJMurphy
Sun Aug 02, 2015 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does more RAM slow down server start times?
Replies: 5
Views: 1872

Re: Does more RAM slow down server start times?

Sorry for the late reply - I only get to look at this forum once a week. The two cfg files are identical (barring server name differences obviously) as they are literally copies of each other. We're on 9.5.1 so I don't think the parameters around multiple threads / persistent feeders or any of that ...
by TJMurphy
Sat Jul 25, 2015 4:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does more RAM slow down server start times?
Replies: 5
Views: 1872

Does more RAM slow down server start times?

Hi guys, long time lurker, infrequent poster. We've just had two of our server boxes upgraded in anticipation of moving from 9.5.1 32bit to something a bit (more) modern. What's puzzling me at the moment is that one box takes over twice as long to start up as the other (48 vs 21 minutes) -- and the ...
by TJMurphy
Fri Aug 15, 2014 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The Top 5 Issues
Replies: 9
Views: 2372

Re: The Top 5 Issues

Well two of my top 5 are tracking contacts and also something that tracks reporting performance by our business units.

The other ones are more traditional uses :D
by TJMurphy
Sun Jul 20, 2014 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Host & RAM Usage
Replies: 6
Views: 3193

Re: TM1 Server Host & RAM Usage

Not sure if this helps you but here's what I do. Our IT folk don't allow us to monitor RAM on the servers (no login access) and as we're still on 32 bit it's obviously a problem. I've set up a .bat file that runs this line and then I can read the .txt file (as I do have access to the data folder). T...