Dynamic Reports

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

TM1 Excel Reporting Best Practices – Control Tab

Posted on Feb 14, 2019 by Andrew Walker

Excel is still the tool of choice for TM1 users to create reports and forms. They can be opened directly in Perspectives or Planning Analytics for Excel or via the…

Creating a Dynamic Print Area in a Dynamic Report in TM1

Posted on Dec 3, 2018 by John

I was working on a Dynamic Report today and needed to have some selection criteria visible at the top of the report that I did not want to print. Easy…

Virtual Dimensions in TM1 and Planning Analytics Explained

Posted on Nov 1, 2018 by John

What are Virtual Dimensions? Virtual dimensions in TM1/Planning Analytics are an excellent way of adding new analysis capability to a TM1 cube without changing the underlying structure of the cube…

How to Create a List Report using a TM1 Dynamic Report

Posted on Oct 16, 2017 by John

Ever wondered how to create an Excel list report over a TM1 cube that dynamically expands based on filters so you always get all relevant rows? Well you can, by…

Creating Dynamic Subsets in TM1

Posted on Dec 3, 2015 by John

Have you ever needed to have a TM1 subset that automatically includes all elements? What, I hear you say, doesn’t that always occur? Well, no.  You can have static subsets…

DBRW TM1 Excel Syntax and Use

Posted on Oct 30, 2015 by John

DBRW is an Excel based function for use with TM1 that retrieves a value from a specific intersection of a cube TM1 and allows users to enter a value into a…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!