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.
SwapAliasWithPrincipalName TI Function – How to Use and Syntax
Here we explain how to use the Swap AliasWithPrincipalName function in TM1 to swap the contents of an alias with the primary ID’s of a dimension.
Sending Cube Data into a Database
Create a new Turbo Integrator Process For now we won’t set the data source for the TI Process because we want this to be a Cube View that we create as the first step (Prolog procedure). So the first thing is to create the view and assign dimensions subsets which will filter the rows of […]
Drill Through Processes in TM1: How to Create Them
In this quick tutorial I’m going to demonstrate how you would go about creating a TI Process which retrieves information from a source system. At my latest clients site we have a process which retrieves actual journals from PeopleSoft just from drilling on aggregate actual data. How a Drill Through Process Works 1) The Drill […]
Naming Conventions and Syntax
Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public Subsets, Processes, Chores and Applications are all named on creation. All too often naming conventions are disregarded within the initial development stages of a TM1 implementation. Usually an attempt is made to bring these in at a […]
The Definitive Guide to Turbo Integrator Troubleshooting
Here is all you need to know about TM1 Turbo Integrator processes. What they are, how they work and how to debug them.
Clear Cube Process
It is good practice to create and destroy a view for clearing rather then leaving a large clear view sitting under the cube waiting for a user to click on it. The code below creates a view and assigns subsets to that view, zero’s the view out then destroys the view and subsets.