Excel Reports

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.

How to Create a List Report using a TM1 Active Form

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.

Creating basic Top 10 reports using MDX expression

Here is a fully worked example of using MDX in a TM1 Dynamic Report to create a Top 10 style report. It includes the dynamic subset, view, dynamic report and MDX.

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