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
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
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
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
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
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
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
Keen to chat? Book a discovery call!
