Search found 74 matches

by TJMurphy
Sat Dec 02, 2023 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirantis and PAW
Replies: 2
Views: 9792

Re: Mirantis and PAW

I'm not going to say we have a lot of experience but we are in the process of doing it on an upgrade now. We're also a Windows environment. Because there was a gap between us buying the licence and then grabbing the software I remember it being difficult to find the download link, the Mirantis websi...
by TJMurphy
Sat Jul 30, 2022 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Font Size between Citrix Workspace and Windows Desktop
Replies: 3
Views: 1807

Re: Font Size between Citrix Workspace and Windows Desktop

For what it's worth, and this is not Citrix related ... I have an external 4K screen as well as the laptop screen. If I start Excel with both screens active then I get small fonts in Perspectives. But if I switch to a single screen, fire up Excel and then switch to a second screen I get the larger f...
by TJMurphy
Sat Apr 24, 2021 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 202105 - What's your security mode poison?
Replies: 6
Views: 4400

Re: Monthly Poll 202105 - What's your security mode poison?

Would love to make some form of SSO to work but our IT folks guard the knowledge about how to integrate with it like the secret of life. Currently trying again with using PAW to let us move to PafE -- that's proving to be a whole other set of fun. Had SSO working within Perspectives but only in one ...
by TJMurphy
Fri May 22, 2020 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: import file from a specific network
Replies: 6
Views: 3131

Re: import file from a specific network

We've just been through this at our place. So, for what it's worth, we ended up having to qualify the network names more completely. For example, \\server\fileshare\folder needed to become \\server.some.domain.stuff\fileshare\folder Not sure if it was unique to our setups but the reason explained to...
by TJMurphy
Wed May 06, 2020 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Buttons - Navigation in Perspectives v Web
Replies: 3
Views: 2575

Re: Action Buttons - Navigation in Perspectives v Web

Thanks both - sorted. We had been using a Cell("filename") function on the original model to work out which set of reports was currently in use (by extracting the sub-part that said it was in the "draft" or "final" report folder. We had (belatedly) spotted that the &quo...
by TJMurphy
Sat May 02, 2020 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Buttons - Navigation in Perspectives v Web
Replies: 3
Views: 2575

Action Buttons - Navigation in Perspectives v Web

Hi all, Long time lurker, minimal poster (but I do try and read it all!). Short Version: Has anyone successfully used a DBR(W) formula to provide the link file for an action button to support dynamic navigation through report packs? Long Version: We use (almost) duplicate application folders to give...
by TJMurphy
Mon Jul 01, 2019 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 2.0.6 - Bogus Timeouts
Replies: 4
Views: 3820

Re: TM1 Web 2.0.6 - Bogus Timeouts

We just upgraded our system to PA 2.0.6 over the weekend and a couple of users (well, me so far but I'm expecting more as they get to the office today) hit this one. Ops Console was fine by the way. The password change trick didn't work for me (either via Perspectives or Web). But what does seem to ...
by TJMurphy
Fri Apr 05, 2019 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA API Changes for Excel 64 bit?
Replies: 3
Views: 3394

Re: VBA API Changes for Excel 64 bit?

Awesome, thank you. I can't easily get onto this forum from work so get back here less often than I like. I'm having some other wierd behaviour too - edit a Declare line, even to just add a space and I'm getting Out of Memory. I'm off to try and run a repair on Excel as well as follow through on the...
by TJMurphy
Fri Mar 29, 2019 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA API Changes for Excel 64 bit?
Replies: 3
Views: 3394

VBA API Changes for Excel 64 bit?

Hi all, Our company has decided to roll out 64bit Excel on us with minimal advance notice (yay us!). So, I've got a brand new test PC and installed Office 64bit on it. I also installed the TM1 Perspectives 64 bit addin. So far so good, I can connect to the server, run reports and so on. Testing is o...
by TJMurphy
Wed Feb 27, 2019 8:34 pm
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 45104

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

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 go...
by TJMurphy
Sun Feb 24, 2019 11:37 am
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 45104

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 o...
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: 6315

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

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

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

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

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

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 ...
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: 12842

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 thin...
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: 4675

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!