Reporting

Format an Excel Report to show Thousands

Here we explain how to format an Excel based report to show values in thousands, even though the source is in whole numbers.

Cell Annotations in Planning Analytics for Excel

Annotations in Planning Analytics for Excel allow you to record notes on a specific cell of a TM1 cube direclty in PAX or PAW.

Planning Analytics for Excel (PAX) Ribbon Not Visible

The Planning Analytics for Excel ribbon is somewhat unreliable. Here we explain what drives the PAX toolbar, the add-ins and how and what to activate and a registry change that might be required.

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.

Display TM1 Attributes in Cognos Analytics Crosstab

Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.

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 Service Request

URL to Log an IBM Cognos or IBM TM1 Support Call

Here is a quick link to the IBM support website. From it you can log Cognos Support tickets and create TM1 Support Requests, directly with IBM.

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.

Creating a Dynamic Print Area in a Dynamic Report in TM1

Need to create a dynamic print area in a TM1 Dynamic Report or Active Form? Here are detailed instructions of exactly how to do this really easily!

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