Reporting from Excel: Methods and Best Practices

Presenting a series of posts all about reporting using Excel. From Traffic Lights to GL analysis, Top 10 reports and just creating list reports.

01.

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

Do you have slow reports with large subsets using MDX? Here's a best practice guide with...

johnv Vaughan

4 min read

Read

02.

Excel Functions | Reporting | Reporting Case Studies

How to Display Traffic Lights using TM1

Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to...

johnv Vaughan

3 min read

Read

03.

Dynamic Reports | Excel Functions | Excel Reports | Reporting

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...

johnv Vaughan

3 min read

Read

04.

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

johnv Vaughan

4 min read

Read

General Ledger Analysis in Planning Analytics

05.

Exploring TM1 | Reporting | Reporting Case Studies | TM1 Case Studies

General Ledger Analysis with TM1

Do you have Excel based TM1 reports with hard coded Excel SUM formulae? Or manually entered line...

johnv Vaughan

4 min read

Read

06.

Dynamic Reports | Excel Functions | Excel Reports | Reporting

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...

johnv Vaughan

2 min read

Read

07.

Dynamic Reports | Excel Reports | Reporting | Reporting Case Studies

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...

johnv Vaughan

3 min read

Read

08.

Dynamic Reports | Excel Reports

TM1 Perspectives Excel-based Report Methods

Here is another minor extract from TM1 Tutorials.com training material. We talk through the common...

johnv Vaughan

4 min read

Read

Reporting from Excel: Methods and Best Practices

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

How to Display Traffic Lights using TM1

TM1 Excel Reporting Best Practices – Control Tab

Creating a Dynamic Print Area in a Dynamic Report in TM1

General Ledger Analysis with TM1

How to Create a List Report using a TM1 Dynamic Report

How To Create the Top 10 Basic Reports Using MDX Expression

TM1 Perspectives Excel-based Report Methods

Log In