Tag Archives: VBScript

How to Import all Files in a Directory

We’ve recently been on a Property Management project using TM1 to deliver a Management, Planning and Reporting Solution. The Client has properties which are managed by an external property manager who produces tenancy schedules and general ledger reports for data consumption. The Problem: Every properties reports would come from the external property manager in a different file. Making the process to load these into TM1 only mildly faster than using … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged ExecuteCommand, ExecuteProcess, IBM Cognos TM1, TI Process, TurboIntegrator, VBScript. Bookmark the permalink. | Tagged ExecuteCommand, ExecuteProcess, IBM Cognos TM1, TI Process, TurboIntegrator, VBScript | 2 Comments

Sending Emails from TM1 (Part 1: Plain Text)

Sending Emails from TM1 – Using HTML Problem: Although some additional components of TM1 have built-in email functionality, TM1 does not have email functionality built into its ETL Engine. Solution Process: Within a TI Process output text to a file to be used as the body of the email to be sent. Execute an email script command to send off the email to recipients. Executing the TI script: The TM1 … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Email Alerts, Email Notifications, IBM Cognos, TI Email, TI Process, TM1, Turbo Integrator, VBScript, VBScript Email. Bookmark the permalink. | Tagged Email Alerts, Email Notifications, IBM Cognos, TI Email, TI Process, TM1, Turbo Integrator, VBScript, VBScript Email | Leave a comment