Search found 15 matches
- Sat Mar 12, 2011 6:35 pm
- Forum: Cognos Planning and BI
- Topic: Unable to publish from Contributor
- Replies: 1
- Views: 44285
Unable to publish from Contributor
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...
- Wed Feb 16, 2011 7:53 am
- Forum: Cognos Planning and BI
- Topic: Intermittent Error when Saving
- Replies: 1
- Views: 3824
Intermittent Error when Saving
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...
- Fri Feb 11, 2011 12:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel 2007 disables automatic refreshing of formula fields..
- Replies: 2
- Views: 2407
Re: Excel 2007 disables automatic refreshing of formula fiel
Thanx I will try that
- Wed Feb 09, 2011 9:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel 2007 disables automatic refreshing of formula fields..
- Replies: 2
- Views: 2407
Excel 2007 disables automatic refreshing of formula fields..
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...
- Mon Jan 31, 2011 5:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ti Process (and lifecycle of a variable in it....)
- Replies: 9
- Views: 7023
Re: Ti Process (and lifecycle of a variable in it....)
Thanx you're a star!
- Mon Jan 31, 2011 4:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ti Process (and lifecycle of a variable in it....)
- Replies: 9
- Views: 7023
Re: Ti Process (and lifecycle of a variable in it....)
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...
- Mon Jan 31, 2011 6:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ti Process (and lifecycle of a variable in it....)
- Replies: 9
- Views: 7023
Re: Ti Process (and lifecycle of a variable in it....)
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);...
- Sun Jan 30, 2011 11:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ti Process (and lifecycle of a variable in it....)
- Replies: 9
- Views: 7023
Re: Ti Process (and lifecycle of a variable in it....)
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...
- Sat Jan 29, 2011 3:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help with "If" Statement please...
- Replies: 8
- Views: 9017
Re: Help with "If" Statement please...
Thank you so much for your help tomok!
- Sat Jan 29, 2011 3:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ti Process (and lifecycle of a variable in it....)
- Replies: 9
- Views: 7023
Ti Process (and lifecycle of a variable in it....)
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...
- Thu Jan 27, 2011 5:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help with "If" Statement please...
- Replies: 8
- Views: 9017
How to create a "Running Total" in TI Process
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...
- Thu Jan 27, 2011 5:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: asciioutput
- Replies: 4
- Views: 3284
Re: asciioutput
Thankyou guys
I'm a newbie
I'm a newbie
- Thu Jan 27, 2011 12:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: asciioutput
- Replies: 4
- Views: 3284
asciioutput
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...
- Thu Jan 27, 2011 7:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help with "If" Statement please...
- Replies: 8
- Views: 9017
Re: Help with "If" Statement please...
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...
- Wed Jan 26, 2011 5:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help with "If" Statement please...
- Replies: 8
- Views: 9017
Help with "If" Statement please...
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...