Search found 15 matches

by Lorna
Sat Mar 12, 2011 6:35 pm
Forum: Cognos Planning and BI
Topic: Unable to publish from Contributor
Replies: 1
Views: 1963

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...
by Lorna
Wed Feb 16, 2011 7:53 am
Forum: Cognos Planning and BI
Topic: Intermittent Error when Saving
Replies: 1
Views: 1044

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...
by Lorna
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: 739

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...
by Lorna
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: 2500

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...
by Lorna
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: 2500

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);...
by Lorna
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: 2500

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...
by Lorna
Sat Jan 29, 2011 3:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with "If" Statement please...
Replies: 8
Views: 3947

Re: Help with "If" Statement please...

Thank you so much for your help tomok!
by Lorna
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: 2500

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 initialis...
by Lorna
Thu Jan 27, 2011 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with "If" Statement please...
Replies: 8
Views: 3947

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...
by Lorna
Thu Jan 27, 2011 5:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: asciioutput
Replies: 4
Views: 858

Re: asciioutput

Thankyou guys

I'm a newbie :P
by Lorna
Thu Jan 27, 2011 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: asciioutput
Replies: 4
Views: 858

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,adate,aservt...
by Lorna
Thu Jan 27, 2011 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with "If" Statement please...
Replies: 8
Views: 3947

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 simulate ...
by Lorna
Wed Jan 26, 2011 5:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with "If" Statement please...
Replies: 8
Views: 3947

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...