TM1 Forum

thanks for the advice - I'll test it out tomorrow when I'm back at that client

hi, I'm running 8.4.2 and Excel 2003 i have to load the data from a series of txt files where i will know the opening batch number and the closing batch number but the numbers will not be complete - some relate to a different company that i don't want to load - they won't be in the folder so won't g...

knowing that the log is GMT is helpful - I'm on 8.4.2 so don't think i can change this what seems to be happening is that the 'system' is deleting the security cube associated with the dimension - that's why i can see on the log that when i reactivate the security it is updating from a blank 'cell' ...

Hi, I'm using 8.4.2 and Excel 2003 I want to lock users out of previous forecasts, elements in a dimension Right click on the dimension, choose security, change the status for all user groups to read from write and save. Close and then go back through the process to check it works...which it does. T...

Hi Using 8.4.2 and Excel 2003 I have a dimension with 1.5m elements. No hierarchy other than a total items - its a list of jobs raised over the last 5 years The element attrubute cube is 161MB The cube using the dimension is very clunky when using the cube viewer. Its 68MB Any thoughts on easing the...

seems too simple...but then the best solutions usually are

this is despite the process having the deimal point and thousand separators defined?

I'll try it tomorrow

thanks

hi, I'm using TI in 8.4.2 with Excel 2003. I'm reading a csv file into a cube. I'm getting an error message Error:Metadata procedure line (0):Cannot convert field number 25, value "-73,743.00" to a real number I have tried using text to columns to format the column to ensure it is a value ...

i think you are right that the alias names have to be unique - i came across that last week - TM1 won't let you save the dimension until it is fixed it turned out teh solution was that i had defined two variables in the Metadata tab - when i moved them to the Data tab it all worked fine so i don't k...

thanks - I'll try that tomorrow

Hi, I'm sorry if this will sound a bit vague, but I'm helping the MOD with a TM1 application, I'm not allowed to see the internet at work, send files home or bring out paperwork (might smuggle something out via wikileaks if this plea for help doesn't work) - so the following is my recollection of th...