TM1 Forum

For repeat totals in excelsheet cells use Conditional Formatting with Formula =0=0 (or other signs that you use in Format Range) and black color font.

Thank you guys. Great code and examples! I little will update the topic. First In TM1 Drill Process in the Prolog Tab write (Thx rmackenzie ): vUserLogin = TM1User () ; vUserName = ATTRS ( '}Clients' , vUserLogin , '}TM1_DefaultDisplayValue' ) ; ##### Company # variable for generated SQL sSQL=''; # ...

First: Create three processes : ChoreLoggingBegin with code in Epilog : StringGlobalVariable('MailMessage'); MailMessage = CHAR(13) | '*** Start Logging ***' | CHAR(13); ExecuteProcess('ChoreLoggingResult', 'bInit', 0, 'sProcessName', ''); ChoreLoggingEnd with code in Epilog : SetInputCharacterSet(...