TM1 Forum

Hi all I have got LockPagesInMemory = T i will try turning this off to see if this is the cause, but as the help file says this wont really affect if the data is continuously accessed and while running a TI its being accessed alot. This system works perfectly on a local machine my laptop for instanc...

Hi all, I have built a TM1 system that truncates millions of records within a string of 12 TI Processes it works fine on a local machine but when i install it on a server when running the processes it kicks me off the RDP and then the server refuses me access and the IT team access so it has to be c...

My Version of TM1 is fully updated to patch 6 and the interim, SSL is fine and my Server shows perfectly in architect.

no it still says Sever connection failed

apologies i meant the install was on E:, i added the runti second part due to a previous post

hi thanks for the assist bud, still no joy. i read that the location of a tm1 installation can attribute to this issue, my tm1 installation is n d:, my instance is in a seperate folder on d: current bat: "e:\Program Files\ibm\cognos\tm1_64\bin64\tm1runti.exe" tm1runti -process "Save D...

Thanks for the above guys, I tried all the above still the same thing, Do i need to check my firewall settings?

Hi Kenship

have you tried creating a Chore Manager TI that runs every hour/20 minutes and runs your TI's in the order you specify rather than quitting chores etc?

I found the interim fix patch 6 seemed to fix the SSL issue automatically

Hi all is anyone able to help me with my RunTI.exe, never used it before but thought i would expand my horizons :D heres my Batch file "E:\Program Files\ibm\cognos\tm1_64\bin64\tm1runti.exe" -process "TestTi"-adminhost "localhost" -server "BasicSetup" -user &q...

I thought I was missing something, thank you it been a long working night!

https://gyazo.com/b3e549ed208e21f6e3fdd8b1b0b0f219

heres what im using but it keeps altering my subnms and loading to the range

Hi all I have used Action buttons in TM1 web before to navigate back and forth using drill throughs from DBRW to Subnms and subnms to subnms however never used the DBRW to range drill through before. Can someone tell me if this is a fault with tm1 or just the way im doing it. when i do the DBRW to R...

When the report shows in bi it uses the the login options of the user within tm1.

You need to turn off the web options in client settings within tm1

Savecubedata(cubea)

Turn off logging function in the TI it should commit after every TI that's written in

I use this methodology on a daily basis within 10.1 I run a top line value to a pl that no one can see called chkpl and in my regions and customers I have chkreg and checkcus this gives me an nth level in the cube to get a comparison against the real hierarchies I then just cellgetn my check values ...

Thanks alan :D I have just finished my own using the math approach I left it in the column un stripped and passed each part: pStartTime = 2013-11-08 21:28:19.002 vTimestamp = 2013-11-08 21:28:23.011 #Start# vElapsedTime= Numbertostring((( #Day# ((stringtonumber(subst(vTimeStamp,9,2))-stringtonumber(...

wo there alan, I said i had stripped the values from the string to a simple string without the ":" and "-" (apologies from putting a 6 in my example unfortuantely I cant seem to copy and paste from my TM1 directly into here (sometimes it works sometimes it doesnt) I have a proble...

does this not convert a serial number to a string ?

hi this example already is a serial number using Now its a predetermined Date and Time I have and need to use, so converting back to a time serial number is needed first, I have read alan Kirks info on time and seen dayno is good for getting a serial number but the example only shows using a date go...