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.

This entry was posted in Logging, TI Functions and tagged CubeSetLogChanges, Transaction Log. Bookmark the permalink. | Tagged CubeSetLogChanges, Transaction Log | Leave a comment

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!

This entry was posted in Logging, TM1 Admin and tagged logging, Transaction Log. Bookmark the permalink. | Tagged logging, Transaction Log | Leave a comment

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.

This entry was posted in Cognos BI, Configuration, Installation, Security and tagged bi interop, CAM Security, planning.html, pmhub.html, Security, TM1p.ini, tm1s.cfg, tm1web.html. Bookmark the permalink. | Tagged bi interop, CAM Security, planning.html, pmhub.html, Security, TM1p.ini, tm1s.cfg, tm1web.html | Leave a comment

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.

This entry was posted in Security, TI Coding, TM1 Admin, TM1 Administration, Turbo Integrator and tagged CAM Security, element level security, Element Security, Security. Bookmark the permalink. | Tagged CAM Security, element level security, Element Security, Security | 1 Comment

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.

This entry was posted in Planning Analytics, TM1 Admin, tm1s.cfg and tagged Dates, Excel, Planning Analytics, UseExcelSerialDate. Bookmark the permalink. | Tagged Dates, Excel, Planning Analytics, UseExcelSerialDate | Leave a comment

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!

This entry was posted in Errors, Excel, Planning Analytics and tagged Café, Errors, Excel, Excel Addin, PAX, Planning Analytics. Bookmark the permalink. | Tagged Café, Errors, Excel, Excel Addin, PAX, Planning Analytics | 1 Comment

“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.

This entry was posted in Attributes, Data Connection, TI Data Sources, TI Processes and tagged Attribute, Dimension, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Attribute, Dimension, TI Process, Turbo Integrator | Leave a comment

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

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged ETL, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged ETL, TI Process, Turbo Integrator, TurboIntegrator | Leave a comment

Planning Analytics Supported Environment

Updated April 2018 – with supported environment for Planning Analytics Local v 2.0.4. 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 be very large and … Continue Reading

This entry was posted in Installation, Planning Analytics and tagged Installation, Planning Analytics, Server Configuration. Bookmark the permalink. | Tagged Installation, Planning Analytics, Server Configuration | Leave a comment

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

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged data connectivity, secure gateway. Bookmark the permalink. | Tagged data connectivity, secure gateway | Leave a comment