TM1 Forum

Hi,

Has anyone tried to change the query criteria and auto-refresh the in-spreadsheet browser via VBA?

Many thanks
Ross

Hi, I've written a dynamic view using MDX. I would now like to copy the values in this view to another dimension element. One approach would be to import the view into another process and use Cellputn to transfer the value into the new element. But it would be good to be able to do this within the s...

Thanks for your quick reply lotsaram,

We're currently looking at upgrading but in the meantime I've decided to do it using VBScript, net send and the TM1 userIDs.

Does anyone know if via code in TI it is possible to broadcast a message to users? This would be a useful automated function to warn users when TI processes are run which slow the server.

Regards
Ross

Hi David, Thanks for your reply David. It's definitely TM1 that I'm referring to. The reason for the Dimension idle time lock idea is that we have 4 users with admin access (not ideal I know) so we need to ensure that if someone writes to a period, for forecasts as an example, that it is closed so t...

We would like to lock down periods prior to the current period which have been idle for more than 10 minutes.

Has anyone implemented something similar or know whether it is possible to determine idle time for dimensions?

Many thanks
Ross

Hi Steve, Thanks very much for your quick and indepth response to Cheng's question. I am new to TM1 but have a reasonable background in VB/VBA and SQL. I think I understand your approach but please excuse me if my question is stupid. The two charts we have start at different levels - i.e. Chart 2's ...