Loading...

N0PAX – Reporting with IBM Planning Analytics for Excel (PAX)

Home / N0PAX – Reporting with IBM Planning Analytics for Excel (PAX)

Course Outline:

TM1 Planning Analytics for Excel Overview

  • TM1 Planning Analytics for Excel
  • TM1 PAx Layout
  • PAx Interface Options
  • PAx Toolbar Buttons

PAx Cube Viewer and Set Editor

  • PAx Cube Viewer
  • Set Editor

Explorations

  • Explorations from an Existing Cube View
  • Explorations From Scratch

Quick Reports

  • Quick Report Basics
  • Quick Report with Additional Features

Custom Reports

  • Creating a Custom Report

Dynamic Reports

  • Creating a Dynamic Report

Appendices

  • Appendix A - TM1 Worksheet Functions
  • Appendix B - Supported MDX Functions for Subsets

Course Audience & Prerequisites:

Audience

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

Prerequisites

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:

Course Offerings:

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.

  • Course Outline
  • Course Audience & Prerequisites
  • Course Offerings
  • Related Courses

TM1 Planning Analytics for Excel Overview

  • TM1 Planning Analytics for Excel
  • TM1 PAx Layout
  • PAx Interface Options
  • PAx Toolbar Buttons

PAx Cube Viewer and Set Editor

  • PAx Cube Viewer
  • Set Editor

Explorations

  • Explorations from an Existing Cube View
  • Explorations From Scratch

Quick Reports

  • Quick Report Basics
  • Quick Report with Additional Features

Custom Reports

  • Creating a Custom Report

Dynamic Reports

  • Creating a Dynamic Report

Appendices

  • Appendix A - TM1 Worksheet Functions
  • Appendix B - Supported MDX Functions for Subsets

Audience

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

Prerequisites

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.