Search found 29 matches
- Tue Nov 13, 2012 8:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: n element KEY ERR
- Replies: 5
- Views: 3606
Re: n element KEY ERR
The user has tried to a full reboot and it didn't work. The only thing that seems to resolve the issue is restarting the server instance.
- Wed Nov 07, 2012 9:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: n element KEY ERR
- Replies: 5
- Views: 3606
Re: n element KEY ERR
An update to this post. The user experiences this problem after a change to a dimension such as moving a cost center. The problem goes away after the service is restarted. No other users are having this trouble.
- Thu Nov 01, 2012 7:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: n element KEY ERR
- Replies: 5
- Views: 3606
n element KEY ERR
We recently moved from 9.5.1 to 10.1 and one user is expereincing an error when he is using the ISB. He can see data at the consoldiated level but gets KEY ERRs at the n element level. He has admin rights so I don't believe it is a security issue. Any suggestions?
Thanks
Thanks
- Mon Oct 29, 2012 3:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Greenplum
- Replies: 3
- Views: 2693
Re: Greenplum
Thanks for the help. I will give it a try.
- Thu Oct 25, 2012 3:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Greenplum
- Replies: 3
- Views: 2693
Greenplum
Has anyone connected to Greenplum through ODBC? I am going to try and get some data out of Greenplum and I would like to know where to get an ODBC connection . I am on TM110.1fp1 using Excel 2010.
Thank you
Thank you
- Fri Sep 30, 2011 1:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Trouble with N: and C: rules
- Replies: 3
- Views: 2670
Re: Trouble with N: and C: rules
Paul/qml,
Thank you for your replies. I had considered Consolidatechildren but I have read that it should be avoided if possible. I will try the calculation at the N level first. I wanted to make sure there wasn't an alternative I didn't know about.
Thanks again.
Thank you for your replies. I had considered Consolidatechildren but I have read that it should be avoided if possible. I will try the calculation at the N level first. I wanted to make sure there wasn't an alternative I didn't know about.
Thanks again.
- Thu Sep 29, 2011 8:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Trouble with N: and C: rules
- Replies: 3
- Views: 2670
Trouble with N: and C: rules
Hi All, I am using TM1 version 9.1.2 and have AllowNandCrules (don't remember the exact syntax) in the config file. My problem is I'm trying to write a C and a N rule and then consolidated the two together. ['US Unallocated','Toll']=C:DB('P&L','actual','Total',!Co&cost,'Tolls',!amonth)*(DB('...
- Tue Mar 22, 2011 8:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Upgrade from 9.1.2 to 9.5.X
- Replies: 2
- Views: 2242
Re: Upgrade from 9.1.2 to 9.5.X
Thanks for the help. I will give it a shot.
- Fri Mar 18, 2011 5:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Upgrade from 9.1.2 to 9.5.X
- Replies: 2
- Views: 2242
Upgrade from 9.1.2 to 9.5.X
I want to upgrade from 9.1.2 to 9.5. Is there a 32 bit version of 9.5? Will it work in Windows 2003 and/or Windows 2007? Is it simple enough that a person with a financial background (not IT) can do it? Is there anything I need to know before I try it? I would like to try this on a laptop first to m...
- Wed Aug 11, 2010 6:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder issues
- Replies: 1
- Views: 1938
Feeder issues
Hey All, I am trying to write a inter-cube rule and feeder in TM1 v9.1.2. I can't them to work. Here is what I am trying to do: I am pulling data from a statistically cube and a financial cube to make a customer profitability cube. I can't get the rule to work for the statistics that brings in conso...
- Thu Nov 05, 2009 5:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Schedule chore for a specific time
- Replies: 12
- Views: 100852
Re: Schedule chore for a specific time
Thanks
I assume I would put this in the prolog tab of the TI process?
I assume I would put this in the prolog tab of the TI process?
- Thu Nov 05, 2009 3:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Schedule chore for a specific time
- Replies: 12
- Views: 100852
Re: Schedule chore for a specific time
Thanks Jim. I did think about doing that but there is not an option to schedule the chore to only run it from 8am to 6pm. Do you know how to do that?
Thanks
Thanks
- Thu Nov 05, 2009 3:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Schedule chore for a specific time
- Replies: 12
- Views: 100852
Schedule chore for a specific time
I would like to have a chore run only M-F from 8am to 6pm. I would imagine I put the syntax in the prolog tab of the TI process I am running in the chore. Can anyone help me with the syntax. I would be forever greatful.
Thanks,
Mark
Thanks,
Mark
- Fri Jul 31, 2009 6:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Re: Feeder with N: not working in feeder
Thanks for the help! I finally figured out what you were saying. Here is the final result that worked. #Feeds historical (Actuals for Forecast Base of Actual and Previous Year from Forecast Base of Forecast) from the Unit Record cube to the Base version# ['Units','Haul','Base'] = N:DB('Unit Record',...
- Wed Jul 29, 2009 9:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Re: Feeder with N: not working in feeder
Thanks everyone. I am going to try all the suggestions and I'll let you know.
- Wed Jul 29, 2009 6:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Re: Feeder with N: not working in feeder
Michel, I see your point and I have changed the rule and the feeder to the following: Rule ['Units','Base'] = N:DB('Unit Record', 'ASHI Consolidated', !CoCost, 'ASHI Consolidated', !Customer Accounts, 'Total', 'Total', !Load Type, IF((ATTRS('Month', !Month, 'Forecast Base')@='Actual'),!Month,ATTRS('...
- Wed Jul 29, 2009 11:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Re: Feeder with N: not working in feeder
Almost. The rule pulls from the previous year if the Forecast Base is "Forecast" and not "Actual". This was put in there so we don't have to use the most current month if know there are going to be adjustments made to the month.
- Wed Jul 29, 2009 11:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Re: Feeder with N: not working in feeder
Michel, For the current year if the month has final numbers I want the actuals, if not I want to pull in the previous years numbers. This will be the base of the forecast. I will build on the Actuals+Previous year to make the new forecast numbers. For example, Jan-Jun has the actual units and then I...
- Tue Jul 28, 2009 6:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Re: Feeder with N: not working in feeder
Martain, Thanks for the quick reply. I tried to input the dimension name before without the single quotes and it can't find the dimension.This is probably becasue Disp Term, Haul Term, Drop Term and CoCost are all identical. They are the same because of our network structure. Anyway. I actually get ...
- Tue Jul 28, 2009 5:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder with N: not working in feeder
- Replies: 13
- Views: 9270
Feeder with N: not working in feeder
I have a feeder that I am trying to create. So far I have the following: source cube: ['Disp Term':'ASHI Consolidated','Drop Term':'ASHI Consolidated','Job_Code':'Total','Plant Codes':'Total','Hauled','Units'] =>DB('Unit Forecast', !Haul Term, !Customer Accounts, 'Units', 'Haul', 'Base', if(attrs('M...