New Upload weather data from web services into TM1/Planning Analytics — Read the post →

The Revenge of TM1 Web

TM1 Web has been one of the main alternative user interfaces to Excel for planning and forecasting applications even since the release as early as back in 1997. This old friend has allowed business users to deploy web applications that can be easily created in spreadsheets.

TM1 Web has never been better! It now comes in IBM Planning Analytics with a modern look and feel, faster websheet load and scrolling, conditional formatting enhancements and iPad support. TM1web also uses several workspace components giving a seamless user experience throughout Planning Analytics.

Quick tips

  • Help your users navigate your system with a low maintenance Menu System

  • Use TM1 Web font – Helvetica Neue (does not work in Excel – it defaults to Arial)

  • Use conditional formatting in moderation

  • Create data validations with TM1 rules

  • Use a colour theme consistently (e.g. grey to indicate read-only cells)

  • Use Emoji or Webdings for small icons (e.g. checkmarks, hearts, etc.)

  • You can use Font Awesome for navigation links

  • Have a clean and consistent layout across all the reports and templates

Next Episode

Understand how to use the REST API and Python to boost and integrate your TM1 server with lots of new technologies:

  • What is the REST API? And how to use it with Python

  • Handy Python scripts to boost your TM1 system

Previous Episodes

  • Episode I: The Excel Hell Menace

  • Episode II: The Attack of Best Practices for Hierarchies