Dynamic Reports

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!

Virtual Dimensions in TM1 and Planning Analytics Explained

Virtual Dimensions and Hierarchies in TM1 and Planning Analytics explained. You can add virtual dimensions, or hierarchies, to any physical dimension in TM1 to expand the analytics available from a TM1 cube. Here we explain what they are.

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.

Creating Dynamic Subsets in TM1

Dynamic Subsets in TM1 and Planning Analytics allow you to create sets of elements that always contain all relevant elements. For example, all children of a parent, or all level 0 elements. They are extremely useful in Dynamic Reports as with them you can be sure that all elements are displayed.

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.

The Infocube 10 Point TM1 Health-Check: Part 1

Part 1 of the Infocube 10 point guide for giving your TM1 environment a Heath Check. A must read for any TM1 administrator.

TM1: Top N Elements from a Tuple

Writing MDX statements is a very helpful skill for a TM1 person, but what if you need to…

How To Create the Top 10 Basic 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.

Replicating a Dimension Hierarchy in Excel

For those of us still using earlier versions of TM1 where Active Forms are not available, below is…

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