TM1 Forum

so close yet so far... can control all calculations except when the action button has been clicked - don't think it is a bug but it is definitely a big oversight!

Iboglix 1 - Me 0

my final solution: UserForm1.Show vbModeless DoEvents Application.Run "TM1RECALC1" UserForm1.Hide using vbModeless arg because I want to display a label on the form but want the form to get closed by the .hide method, because a modeless form cannot show a label had to put the DoEvents stat...

looks like this might be the only way to stop this, how very very annoying!

thanks for the suggestions guys

ah I was trying to be too clever and intercepting any sheet calculation, think wrapping each statement this way could do it (if the end users agree )

hmmm this is not working, problem is when the TI button is working, can intercept the calc event but it is still defaulting the mouse pointer to xlNorthwestArrow, why would you ever want that cursor when excel is in the middle of doing something?!?!

I take it this for your hand crafted vba, not just a shift+f9 calc? What I used to do (I try to steer clear of VBA heavy workbooks now) is create a worksheet that simply says "TM1 is updating, please wait...". Then something like (off the top of my head, you'll have to get the syntax) thi...

jim wood wrote:The other 2 copies of this post have been removed.

The Admin Team.

sorry about that chrome wasn't refreshing the page properly so I didn't the first two had posted.

Hi All, Bit of a funny one this but here goes: Is there any way to stop Excel displaying the normal mouse icon (ie pointer) whilst it is running this: Application.Run "TM1RECALC1" essentially due to some performance issues the mouse pointer is showing whilst a sheet is calculating which my...

I have not had time to properly read you post yet but have certainly had trouble with GlobalVars being reinitialised by processes called by the main process

when I get a mo I'll have a proper read and see if I can help

I would avoid cell_security for very large cubes and use security cube based rules- this is because in my experience the mem usage can balloon if you have a large amount of cells in your cube and I know that you don't want to hear it but if you are already kind of using TI why not continue to use it...

lotsaram wrote: (But then again I have heard people complain that 1 million rows in Excel is not enough so who knows.)

when I first started data analysis I thought this, then i realised i should be using a database

well hopefully someone can come along and help- I assumed you had never had it working before so suggested you don't waste your time trying to make it work if IBM won't support you....

good luck! and post back how you solved the issue when you do

sounds like it wasn't designed to work with Win7 hence the support note mentioning that it wont be officially supported until 9.5.1, 9.4 was probably never tested with Win7 (which may not have been released at that time - cant be bothered to check the dates) and there is probably no desire for them ...

think it may be calling versions from the windows temp directory, have to do a few tests first to confirm but cant work out what else it could be

I don't believe it! I had fixed the formatting and got it to work from TM1, accessed TM1 as a different user and its now calling the old sheet, I don't know where to start!! anyone know what actually happens behind the scenes? I would have assumed: You click the excel shortcut to open the sheet, tha...

something I really struggle with is the link between the excel sheet TM1 calls and the physical sheet on the disk Once I have my sheet saved up to TM1 I often amend it straight from the }externals directory but find that sometimes I can make an amendment, then open it from TM1 and the amendment isn'...

what was your workaround?

can she open a non-tm1 excel file on the server or does she log straight into perspectives? sounds like the excel config on the server aint quite right but if you can access no problem then maybe its to do with her profile I've watched some of my sheets behave very oddly when on citrix, very hard to...

No expert but seem to remember having a similar issue, could it be that an element in your subset has two parents (i.e. belongs to both hierarchies) and that its this that is confusing TM1? not sure how it will help but at least you'll know what you can and cant use as an approval hierarchy - hopefu...

worked round this with a kludge in the end, not ideal but does what I need it to do