TM1 Forum

If your Admin Host has an entry for a previous version of the server somewhere you get this "effect".

Well, I was so bored of the blue colour scheme so it's good to know the next one will be red lol

It's because that's a valid cell reference in the new "wider" Excel. And on our version (9.1SP3 but with clients on mixed Excel 2003 / 2007) there's another nasty little gotcha. It's basically a DBR3 formula through an Excel 2007 model back into an Excel 2003 model causes the server to han...

Any chance it's like the one we have?
http://forums.olapforums.com/viewtopic.php?f=3&t=1673

No solution to ours provided yet - though I'm told it's been elevated to the US engineering (whatever that means).

Tony

Thank you, I look forward to playing with these.

Tony

If I'm connected to a server, then scroll around the worksheet the cursor just stops regularly for a split second and carries on. This occurs in 9.4.1 MR1 FP1 and FP2. On a completely blank sheet, it looks like it's every 10 cells. This only happens when connected to a server. There are no other mo...

Just updating this to add that I'm seeing it on 9.5 running on Office 2007 / Windows XP as well. This time ran Processmonitor and found it was cycling around trying to open a file called "C" all the time. This is just two cycles, but it's doing it every time you move the cursor / click an ...

Have had this on one machine regularly and on another machine once. The only thing that made it go away was a full "Detect and Repair" exercise on Office 2007. And rumour has it that it's back on that machine again too (I've not been able to check yet). As that PC is a different model to o...

HF16 on our Vista / Office 2007 test laptop results in Excel crashing all the time while running our load tests. We were given the HotFix to try and get our performance back (load models were taking 5+ times longer on Vista / Office 2007 / 9.4.1 than XP / Office 2003 / 9.1.3) and also to see if it a...

If you find anyone on quality control from the TM1 side of things, give them a kick from me please.

Up to 9.4.1 MR1 FP2 HF16 and still not working ... Office 2007 with our current version now looking like the only way forwards.

Tony

Hi, been trying to do some serious testing on 9.4 now as we're getting Office 2007 hoisted on us very, very soon! We've only just gotten a "proper" machine from our IT folks with Office 2007 and Vista* on it. Two issues I've not seen mentioned here before, wondering if anyone else has them...

i'd be wary of trying to install it anyway other than via the provider installer. If you get issues it'll be hard for IBM to support you if there are files missing etc, and it's not like their yearly maintenance fees are cheap... In an ideal world I'd agree with you but when the installer program i...

A bit of a left-field approach but I was wondering if you could use VBA to store the current value, send a new value in, check if it's changed (proving write access) and sending the old value back in again to leave things "as they were". The old auditor training in me though is cringing at...

Should your code not simply be this:
(I think even the Application. bit is superfluous but I usually put it in). Not sure what the return value is but it's certainly not a worksheet ...

Tony

No idea why one PC is faster than the other but another optimisation to try is to do a union of all the cells to delete and then delete them all in one go ... This is my code for hiding rows, should be able to do something similar with delete (I've put in the command in a comment at the end). Sub Hi...

@ Steve, we have a bunch of models with this code to manage the Autocalc. However, we've found that if Excel is in auto-calc then the model calculates once *before* hitting the code to switch it to manual (these are models being launched from the Application folder). And, near as I can figure it, th...

We had a play with the "Restart.bat" approach mentioned on that thread, on a test system. In my experience it was more reliable if you did a "SaveDataAll" first. I guess it's a timing issue, the batch file gave up waiting for the cubes to save and hit the start bit too early. Any...

...*or* someone had used the "backout" facility from the message log which didn't seem to create a log file entry. We've banned anyone (mostly me :shock: ) from using the backout facility for a few versions now so that might be fixed. Tony, that's an interesting and somewhat worrying poin...

We're using replication here and it's been fine. However, one server is read-write, the other one is read only so there's no risk of conflicts. I've set up a couple of big reports to check the two servers are in synch and run these once a week. On the rare occassions we've had a problem it seems (ii...

Thanks for this. Our IT people are (up?) grading us to Vista / Office 2007 in the second half of 2009 and I've been looking for everything I can find out about pitfalls. So far I've not been able to have a serious play as they only gave me a VMWare image to play with - configured with 512MB of RAM b...