TM1 Forum

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

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 "filename" parameter wasn't suppor...

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

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

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

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

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

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

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

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

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.

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

Thank you Paul, my searching hadn't turned that one up - my bad.

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

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

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.

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!

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

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

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