Category Archives: Administration

CubeSetLogChanges TM1 function: Syntax and Example

When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn off transaction logging for a TI using the command CubeSetLogChanges.

Who Changed that TM1 Data? Using the TM1 Transaction Log

Have you ever had an inexplicable change to TM1 data? You know, when a user comes to you and says, John (in my case), the data in TM1 has changed since I looked at it last month? Well, if you have, here is the solution. And it is really easy!

How to Change TM1 to use Cognos Security (CAM)

This is a comprehensive guide to configuring TM1 to use Cognos CAM security. It includes why you might connect Cognos security to TM1, TM1 environment changes and how to deploy and configure the BI Interop files to your BI application and gateway servers.

Cascading Element Level Security in TM1

Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.

TM1 and Excel Dates No Longer in Conflict!

TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.

Errors when Connecting to Planning Analytics for Excel/CAFE

Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we go through how to get it all sorted!

“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 relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

Planning Analytics Supported Environment

Updated April 2018 – with supported environment for Planning Analytics Local v 2.0.4 and Windows Server 2016 We are about to start a new project with a client where they will be using Planning Analytics local (i.e. the new version of on premise TM1). They have asked about the server specifications and what needs to be installed. IBM have a great tool that gives all this information, but it can … Continue Reading

How to Create a Secure Gateway for Planning Analytics

There are a couple of elements that must be established to make the secure gateway work. There are server side and local side requirements. This post deals with what has to be done on the IBM server so you can connect it to your local data. For instructions on establishing the local side of the connection, please see this post. Server Side Configuration In the Welcome Kit from IBM, there is a … Continue Reading