Excel Best Practices

Elements, Excel Functions, Excel Reports, TM1 Case Studies

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.

Dynamic Reports, Excel Functions, Excel 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.

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