TM1 Admin

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

Who Changed that TM1 Data? Using the TM1 Transaction Log

Posted on May 28, 2018 by John

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…

Cascading Element Level Security in TM1

Posted on Feb 17, 2018 by John

We are doing a large project at a multi business unit company. The client is very security conscious and wants to ensure t members of a business unit can only…

TM1 and Excel Dates No Longer in Conflict!

Posted on Oct 24, 2017 by John

TM1 dates and Excel dates have been in conflict since the birth of TM1. TM1 used a serial number of 1 for its start date of 1-Jan-1960, while in Excel…

Setting the Java Virtual Machine (JVM) in Cognos

Posted on Mar 2, 2017 by John

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop…

Tuning Cognos BI and TM1 for Maximum Performance

Posted on Mar 2, 2017 by John

Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the out of the box settings. These tuning changes are not difficult and…

Forcing Cognos BI to Use Native TM1 Engine

Posted on Feb 24, 2017 by John

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop…

Order to Restart Cognos and TM1 Servers

Posted on Feb 23, 2017 by John

What order do I use to restart Cognos BI and TM1 servers in a distributed environment? We are currently doing a project where there is a TM1 server, two Cognos…

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

Posted on Feb 22, 2017 by John

Sometimes we need to go further than just knowing the version of TM1 installed. We might need to know, for example, the exact version, fix pack and possibly even interim…

How to Determine the TM1 Perspectives Version Installed

Posted on Feb 22, 2017 by John

Finding out the version of TM1 Perspectives is easy. TM1 Perspectives is an Excel Addin that gives great functionality for using TM1 information in Excel to create forms and reports…

How to Determine the TM1 Version Installed on a Server

Posted on Feb 22, 2017 by John

We are often asked how do I know what version of TM1 I am using? Well here is how you determine the TM1 version you have installed on a server…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles