TM1 Forum

Hi, I am trying to copy the data from ordinary excel sheet into cube view in TM1 Application Web (earlier known as TM1 contributor). In excel, if you double click the cell,it will show as '4000'.Since the format is given as below, it appears as '4,000'. I try to copy this value '4,000' to cube view ...

Hi, We use TM1 10.1(64 bit operating system) and the tm1 server is Windows server 2008 R2 enterprise. Users maintain an excel sheet where the custom format for the value(number) is used as #,##0_ ;-#,##0. When we try to copy the value from excel to cube in tm1 architect, it works fine.But the same v...

Yes, but it skips the data directory folder.

Thanks
Sophie

Hi All,

The file path is e:\tm1_data\tm1_test\logs\sandboxlogs\ABC\User\c\tm1s.log.
Sorry for the confusion.
ABC is the namespace.
User is the username.
c is another folder where tm1s.log file is present
Hope this clears.

Thanks
Sophie

Hi, Our TM1 server is 64 bit with 64 GB RAM.It crashed today with the below error in tm1server.log. This error has not occurred before. 4112 [6a1] FATAL 2014-04-30 02:06:12.829 TM1.System.File TM1 Server Abort: sf_Write() - Write error on file "e:\tm1_data\tm1_test\logs\sandboxlogs\ABC/User\c\t...

Hi, We use 64-bit TM1 server with 64 GB RAM.The version used in TM1 10.1. We have noticed the below error in tm1server.log and this warning is appearing for the first time in the tm1server.log. 1816 [f9] WARN 2014-04-22 04:54:53.115 TM1.Server.Memory al_Alloc() outOfMemory Exception <<< MEMORY_TEMP_...

Hi, I would like to know if Microsoft Excel 2013 is officially supported in TM1 10.2. Actually when I checked the URL http://publib.boulder.ibm.com/infocenter/prodguid/v1r0/clarity-reports/report/html/prereqsForProduct?deliverableId=1284579430418 , I could find that IBM has not even mentioned the mi...

Hi, Could somebody help me with the function of the TM1 control cubes "}SecurityOverlayGLobal_<Cube Name>"? I am not able to find much details about this cube. I too recently had an issue where a user had ownership of the certain node but the intersection of that node and OverlayData eleme...

From outside of TM1 - You could use Windows performance monitor to monitor the processes - tm1admsd, tm1sd and tm1excelservice every few seconds (minutes/hours) round the clock and log their Working sets value into a log file. When the services go down, the Windows perfmon will log "blank"...

In my case, the tm1s.log had entries from before the crash and the subsequent transactions were appended to the same log after the server restarted. The file got saved with timestamp during the next "Save Data". Hence I think, the file is not corrupt. These transactions should be automatic...

Whenever our tm1 server crashes, I notice that the tm1s.log is sitting there in logging directory holding the transactions happened after the last "Save Data". My question is, once the server is restarted, will these transactions be loaded into the RAM and the future transactions be append...

This seems to be a defect which is not fixed in TM1 9.5.2 version too.

Hi, I have formatting and alignment issues while trying to export cube views to PDF in TM1 Web. The "Export to PDF" of Websheets are working as expected and the formatting is intact. But when we do export of cube views, the values of columns get truncated and formatting of the cube view do...

I tried out PowerShell, it looks like it cannot understand the "Tail-File" function and get the below error. Get-content works. The term 'Tail-File' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was inclu...

If this is not 9.5, you will have to make sure if you got "tm1s.lic" file in the data directory.
If it is not there, try copying it from your installation bin directory to the data directory.

@ tomok - Yes, this is what we have been doing right now but it gets increasingly hectic as we have a long list of TM1 instances to check under different admin hosts. @ Andy Key - Thanks for your suggestion. I do not have much idea about API but will go through the guides and let you know if I come ...

Hi, I am looking for some way to find if a TM1 server has finished loading after the recycle. Right now, I keep refreshing my client every few minutes to check if a server is available. I also periodically check the tm1server.log to verify "the server is ready" message. I tried to write a ...