TM1 Management

Planning Analytics Version Management

Here we explain what versions of Planning Analytics (TM1) server, Planning Analytics for Excel (PAX) and Planning Analytics Workspace (PAW) work together to ensure your TM1 environment keeps on working nicely.

TM1 Links

Useful TM1 and Planning Analytics URLs

Here is a collection of useful TM1 and Planning Analytics related URL’s. They include TM1Web, PAW, Ops Console, the Cognos Dispatcher and Gateway

Display user as administrator

How to Define a TM1 User as an TM1 Administrator

Here is a quick explanation how to define an existing TM1 user as a TM1 Administrator.

Use Architect or Perspectives 10.2.x to Planning Analytics

Here is how to use TM1 Architect or Perspectives with both a new and old server environment, so with both older TM1 10.2.2 server and Planning Analytics.

TM1 Web URL

TM1Web URL

TM1Web allows browser based access to TM1 with writeback capability. The TM1 Web URL is http://servername:port/tm1web/, where usually the port is 9510.

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…

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