Search found 4 matches

by nykager
Tue Jun 07, 2011 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: replacing Tm1 with VBA
Replies: 12
Views: 6537

Re: replacing Tm1 with VBA

Thank you very much.

Problem is, noone is skilled in TM1 here, they just want to get rid of tm1 because they think it is to slow.

Is there any 'easy to understand' tutorial online for tm1 or how should I learn about the view formulas?

Thanks again, great forum!
by nykager
Mon Jun 06, 2011 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: replacing Tm1 with VBA
Replies: 12
Views: 6537

Re: replacing Tm1 with VBA

Thank you, but thats not the case, I am in manual calculation when working with Tm 1 files. If I hit F9 my excel will freeze and calculate for 5 minutes or something, then TM1 is updated and I can go on. And my Boss thinks, that VBA is way faster. (My computer skills are decent, it is just the first...
by nykager
Mon Jun 06, 2011 9:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: replacing Tm1 with VBA
Replies: 12
Views: 6537

Re: replacing Tm1 with VBA

We just use Tm1 to bring data from the SAP download to our balance sheets and statements. The formulas in excel look like this: =DBRW("tm1usa:costctr",$B53,$A$1,$C$10,$B$1,$B$2) While B53, A1, C10, B1 and B2 are criterias to sort the data in correctly. Updating these files takes up to 5 mi...
by nykager
Mon Jun 06, 2011 8:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: replacing Tm1 with VBA
Replies: 12
Views: 6537

replacing Tm1 with VBA

Hi, my boss wants me to replace the Tm1 system which we only use to get data from our SAP downloads into the Excelfiles (TM1 v.8 is to slow for her..) Now my question, which may sound very stupid, but can I replace TM1 with VBA codes? I am only an Intern and not really the best in IT questions. :oop...