Exploring TM1 - a Chartertech Company
Search
Close this search box.

How to Display Traffic Lights using TM1

Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to follow to create them and a series of ideas for their use.

General Ledger Analysis with TM1

Do you have Excel based TM1 reports with hard coded Excel SUM formulae? Or manually entered line descriptions on your P&L or Balance Sheet, or a General Ledger cube with negatives for credits and positives for debits, when your users want to see all positive values? Here’s a quick case study for what we achieved for a new client last week that delivers all this and enables the GL cube to be easily used in Planning Analytics Workspace.

Create a TM1 Send Sheet in Excel

Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.

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.

TM1’izing Excel Planning Workbooks

Project Methodology Primarily Applies to Small to Mid Sized implementations of TM1 (3-8 weeks). It’s a widely established practice when scoping a TM1 project to take the legacy Planning Workbooks (where possible) for prior budgets and planning rounds to use as a starting point for company-specific business logic and corporate structures. The advantages of this […]