Exploring TM1

Great TM1 and Cognos content brought to you by Infocube

Discover More Here!

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

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.

How to do a Daily or Weekly Restart a TM1 Model

How to safely save data and shut down a TM1 server (model) when it is run as a Windows Service and then how to restart that TM1 service automatically.

How to Connect 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.

How to Point Docker at a Drive other Than C

By default Docker uses the C drive on Windows to store Docker containers. Here is how to change Docker to use a different drive.

YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

Feeding from a Consolidation to a Leaf Element in TM1

How, in TM1/Planning Analytics, to feed from a consolidated element in one cube to a leaf element in another cube using a single consolidation feeder with a worked example.

TM1 Excel Reporting Best Practices – Control Tab

The Control Tab in Excel is a great way to keep system relevant variables for your TM1 Excel based reports.

PAX Connection Greyed Out

Troubleshooting and correcting a greyed out connection to a TM1 server from within Planning Analytics for Excel.

TM1Web URL

The TM1 Web URL/address is simply http://servername:port/tm1web/, where usually the port is 9510.