Excel Functions

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.


SUBNM Excel TM1 Function: Syntax, Use and Example

SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel, PAX, TM1Web or PAW report or form and open the subset editor to select elements.

Dynamic TM1 Server Name in Excel Workbook

Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.

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.

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 Create a List Report using a TM1 Dynamic Report

Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.

Errors Connecting to Planning Analytics for Excel/CAFE

Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we run through how to get it all sorted!

DBRW Example

DBRW TM1 Excel Syntax and Use

Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display the contents of a specific intersection of a TM1 cube.

DBRA TM1 Excel Syntax and Use

Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display the contents of an Attribute in the Excel sheet.

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1…

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