TM1 Forum

I was just wondering if there's any possiblity to get all root elements?

.members gives me the complete hierarchy back and with filebylevel I need to know the exact level - which can change.

Any other ideas?

There are a couple of ideas in this thread: http://www.tm1forum.com/viewtopic.php?f=3&t=4759 Thanks - but that I did that already. It's useful when I control the refresh itself by VBA. But what I wrote about was the normal TM1 refresh, ie opening an active form. depends on the calculation mode ...

I asked them... "Excel chrashes every 10 minutes!!!" "I don't do anything and it crashes!" and so on ;) I completely tested the hole enviromnent without any problems and when I look over the shoulder it is no problem. But...they still complain about problems. I told them to wait ...

Hi, Is there any possibility to avoid user interaction (mouse / keyboard) while tm1 is refreshing the worksheet? I can't find any event or chance how to detect when TM1 is starting or finishing the process. The block code itself in VBA should be no problem... Background is the following: We have a f...