TM1 Forum

Hi there We are using Planning 8.4 When I try to do a table only view publish, I get an error message: Unable to create the Table Only Layout Publish job. Object doesnt support this property or method Now. I do have a publish container set up and it validates as ok when I test it. Also I have the ne...

Hi I have a problem at a client site. Upon Saving or submitting their plans on the Web, they intermittently get a Java error/errors. I enclose screenshots of that. The client migrated from Oracle to SQL - last year November. They have NOT been working on the live system until now, and now the errors...

Thanx I will try that

Hi We have just upgraded a client from TM1 9.1 to 9.5.1. We are experiencing an interesting situation and I'd like to know if you have some info on that. Our client mainly uses Perspectives for TM1, and thus has the TM1 add in for Excel. Now what happens, if they open up ANY spreadsheet containing f...

Thanx you're a star!

I understand why that substring is returnining what it is. Yes, I am trying to process data that I will be reading from the Data tab. My data on the data tab is in the line of (these are now the dimension names....)..Abank, Aregion,Adate etc etc. Now, depending on what is in the FIRST line of the in...

Hi Alan After our discussion I changed my code to this... cellgetn('atm test', 'Volume', 'abank','ateamno', 'acentre', 'teamtype','Totkm','aregion', 'adate'); IF (subst('adate',5,2) @= '01') ; tmpmonth = 'Jan'; ENDIF; testdate = tmpmonth | ' - ' | subst('adate',1,4) ; ASCIIOutput('if.txt',testdate);...

Thanx Alan So if I understand your correctly, if I want to do a cellGetN in the Prolog tab, I'd have to do it in the format CellgetN('myfield','mycube', abank.....) The element name is abank (specifically referring to that one). That is...if in Architect I expand the dimensions for the cube, that sh...

Thank you so much for your help tomok!

Hi guys I have a TI process....in the Prolog I want to do a once off calc to derive a date (in a different format) from which I am reading in from the cube. Now.... 1. I dont quite understand the 'lifetime' of a variable..meaning...if I define a variable in the "Variables" tab, does it get...

Hi I want to create a running total in a TI process, but I have some trouble doing that. I have a kilometer reading, per line, that I'd like to accumulate. When the accumulation PER REGION (aregion) AND TEAMNUMBER (ateamno) gets over 6250, I want to do the cost calculation with another rate. My code...

Thankyou guys

I'm a newbie

Hi I am using "asciioutput" to output to a file the values calculated in a TI process It errors when I try to output a numeric value. my code... temp = CellGetN('atm test','Volume', abank, ateamno, acentre, teamtype, 'Totkm', aregion, adate); asciioutput ('aa.txt',astats,aregion,ateamno,ad...

Thank you so much for your feedback. After reading all, I think that I would in fact, need to write a rule in stead of a TI Process, because this is something that would need to run "automatically" and not be started by a user or process. Ok. Upon deciding to go the Rule way....how would I...

Hello. I am very new to TM1 and I need some urgent assistance with an 'IF' statement in a TI Process. Basically.... I have a cube that contains a kilometer reading per trip, per team , per region . Lets say the data looks like this: Region A, Team 1, km. I want to accumulate the km, per Team, per Re...