Excel Reports

How to use DefineCalc to Create a User Defined Calculation

One of the most useful features of TM1 is the ability for users to create custom rollups, by…

How to Get an Element ID from an Alias in an TM1 Excel Report

Need to get a primary element name from an alias in a TM1 Excel report? Simple solution for deriving an element principal name in Excel.

ViewConstruct TM1 Function: Syntax and Use

The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.

Thousands Format an Excel Report

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.

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!

How to Take a Snapshot in Planning Analytics for Excel

Here is how to create a snapshot of a TM1 report in Planning Analytics for Excel – PAX. This essentially does a copy, paste special, values on the TM1 formulae only, leaving all your Excel formulae untouched. It is very useful for creating a version of a TM1 report that is disconnected from the underlying TM1 data.

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.

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