TM1 Management

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!

Element Level Security – Cascading through a Dimension 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.

How to Use Excel Dates as Serial Dates in TM1

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.

Setting the Java Virtual Machine (JVM) in Cognos

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using…

Tuning Cognos BI and TM1 for Maximum Performance

Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the…

Forcing Cognos BI to Use Native TM1 Engine

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using…

Restarting Cognos and TM1 Servers

Restart Order for Cognos and TM1 Servers

Here is the order to restart a combined Cognos Analytics and TM1 environment to ensure all connections are re-established correctly.

Using "cmplst" files to find the Exact Version and Fix Pack of TM1 Installed?

Sometimes we need to go further than just knowing the version of TM1 installed. We might need to…

How to Determine the TM1 Perspectives Version Installed

Finding out the version of TM1 Perspectives is easy. TM1 Perspectives is an Excel Addin that gives great…

How to Determine the TM1 Version Installed on a Server

We are often asked how do I know what version of TM1 I am using? Well here is…

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement