How to Unwind a Dimension in TM1
This is a case study of how to unwind a dimension without deleting all the elements. Includes simple TI code that you can use.
How to do a Daily or Weekly Restart of a TM1 Model
How to safely save data and shut down a TM1 server (model) when it is run as a Windows Service and then how to restart that TM1 service automatically.
DimensionCreate: How to Create a Dimensions in a TM1 Process (TI)
To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.
"Joining" Text Files in a TM1 Turbo Integrator Process
How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.
Data Export Tool Review – Flyspeed
Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this […]
Managing Applications from Command Line
Managing TM1 Applications from a command line, or via a Windows batch file. In other words using the TM1 windows based utility “app_maintenance.bat” to execute TM1 processes from Windows.
TM1 10.2 – New Feature: Enable/Disable Applications from Commandline
In this new release of TM1 10.2, a new feature has been added to allow users to perform application maintenance using command line, or in a batch file. The main purpose of this utility is to automate some of the application maintenance, using a combination of standard TI processes and TI processes that execute commands […]
How to Write easily Understood Turbo Integrator Code
Improving Turbo Integrator Code: A Comprehensive Guide
Automating Data Transfers between TM1 Servers
Replicating a Cube from a one TM1 Server into another has never been easier. Follow the steps below to copy a cube from one server to another (this includes synchronising TM1 Dimensions). This process uses the ODBO Provider for TM1 and generated MDX. I was going to show how to create an MDX Query for the desired […]
TM1 Contributor – Single Security Hierarchy
Currently on-site at client installing TM1 Cognos Express. The client wishes to use the contributor application to utilize workflow in the forecast. Doing so can creates a number of limitations, namely security and secondly cube design. Within TM1 Contributor/Cognos Express Planner you apply security based on a single dimension hierarchy for the application you have […]
Sending Emails from TM1 (Part 2: HTML)
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. Text emails will not suffice, you want to employ HTML encoding in your email to provide a more ascetically appealing email. Solution Process: Within a TI […]
Guest Post: Solving a TM1 Performance Problem – Wim Gielis
One of our major customers was facing severe performance problems. The problems related to 2 cubes, in which we wanted to execute a rather tricky elimination. Please follow along while we discuss the cube architecture. We have an allocation cube with the following dimensions: Financial code (10 n elements) Year (2008, 2009, 2010, 2011, 2012) […]
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 […]
Guest Post: Sorting TM1 Text Output – Wim Gielis
First of all, thanks to Ben for inviting me to write this guest article. The case is as follows. Recently, the customer wanted an export from a cube view showing monthly revenue values per project. The user should open the exported file in Excel, modify and import back into TM1. Exporting data to a text […]
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 […]
Nightly TM1 Backups
Learn the importance of regular backups for your TM1 server’s data directory. Discover how to run parallel backups and restore data without IT involvement.
3 Cardinal Rules of Sustainable TM1 Development
We sometimes get asked what are the three most important things to remember in TM1 development to make a TM1 model work well in the long term. Well, here is our take on what you need to do to make your TM1 models sustainable. Never use Names or Descriptions as Elements. This is because change […]
