N0PAX – IBM Planning Analytics for Microsoft Excel (PAx)

Home / N0PAX – IBM Planning Analytics for Microsoft Excel (PAx)

This course introduces PAx; IBM Cognos TM1’s latest Excel-based tool and the successor to the TM1 Perspectives add-in. Students will learn how to extract and input data both to and from TM1 cubes in Excel through multi-sheet, multi-query PAx spreadsheets. This one-day module will cover the creation of Exploration Views, Quick Reports, Dynamic Reports, Custom Reports and Snapshots.

Course Length: 1 day(s)

Course Price: $700 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online

Enroll Now

Course: N0PAX – IBM Planning Analytics for Microsoft Excel (PAx)

1.TM1 Planning Analytics for Excel Overview

1.1         TM1 Planning Analytics for Excel

1.2         TM1 PAx Layout

1.3         PAx Interface Options

1.4         PAx Toolbar Buttons

2. PAx Cube Viewer and Set Editor

2.1         PAx Cube Viewer

2.2         Set Editor

3. Explorations

3.1         Explorations from an Existing Cube View

3.2         Explorations From Scratch

4. Quick Reports

4.1         Quick Report Basics

4.2         Quick Report with Additional Features

5. Custom Reports

5.1         Creating a Custom Report

6. Dynamic Reports

6.1         Creating a Dynamic Report



Users interested in leveraging TM1 data in the Microsoft Excel environment and/or current Planning Analytics Prospective users.


You should have completed TM1 Fundamentals training (Newcomp’s five TM1 Training Modules or the IBM comparable course), or have equivalent TM1 training and experience.

You should also have:

Instructor-Led In Classroom (1 day)

Newcomp can directly deliver courses through the use of in-class training facilities. Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor-Led Online (1 day)

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples. ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.