TM1 Tutorials.com

Posts Tagged ‘TI Process’

How to write easily understood Turbo Integrator code

As many of TM1 consultants know, reading TI code always has the possibility of being a tricky task – especially if it is someone else’s code. This is mostly due to TM1 Perspectives Turbo Integrator lacking Syntax Highlighting (See our Notepad++ highlighter) but in part it is due to poor variable naming, indenting, casing or […]

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 […]

Use Case: Removing the Structure from a Dimension

The Problem: Often when writing dimension update processes from a datasource which is updated automatically we use a standard procedure. Delete all the Elements Add Top Level Consolidations Cycle through (Metadata) Adding Elements and Element Components Cycle through (Data) Adding Aliases But in some cases we are only given a partial data feed.  For example we […]

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 […]