Search found 5 matches

by Benoit
Tue Oct 09, 2018 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 8209

Re: Getting the last date of a month in TI

@ndivine: wow!

It's simple & it's understandable while reading --> nice!

Thanks to all contributers for the suggestions.

Best regards
Benoit
by Benoit
Fri Oct 05, 2018 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 8209

Re: Getting the last date of a month in TI

Hello Wim and PavoGa, many thanks for your inspiring suggestion. Yes I use some Kind of serialisation. Here the workaround (all in TI, not in rules): intM2_brutto = intSourceMonth + intNumberOfMonthToShift; intM2_brutto = intM2_brutto + 1; intM2 = MOD ( 599 + intM2_brutto, 12) + 1 ; intY2 = intSourc...
by Benoit
Thu Oct 04, 2018 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 8209

Getting the last date of a month in TI

Hi, I'm used to get the last day of a month as the day before the first day of the next month: DATES ( myYear, myMonth + 1, 0) This works in Excel well but not in Tm1 TI Process! Month have to be there between 1 and 12 and days have to be between 1 and 28, 29, 30 or 31. Everything else lead to proce...
by Benoit
Mon Nov 14, 2011 4:30 pm
Forum: General
Topic: Excel-wizard to migrate Excel-forms from Alea to Tm1?
Replies: 4
Views: 7422

Re: Excel-wizard to migrate Excel-forms from Alea to Tm1?

Hi Marcus and lotsaram, many thanks for your replies. The Reference update looks cute. I still didn't tested it, but the VB-Code makes a good impression. :D The biggest problem is that, even if Alea and Tm1 are near to each other, some differences make the Find/Replace to a torture: while Alea manag...
by Benoit
Fri Nov 11, 2011 4:43 pm
Forum: General
Topic: Excel-wizard to migrate Excel-forms from Alea to Tm1?
Replies: 4
Views: 7422

Excel-wizard to migrate Excel-forms from Alea to Tm1?

Hi, we are migrating from Alea onto Tm1. Obviously we have a large amount of reports in excel where the functions have to be converted: DBGETC ->DBRW, DE.NAME -> SUBNM, and so on ... I am surely not the first one who have to cop with this. Does anyone know about Excel-assistent which can enlight the...