TM1 User Fundamentals - 2 days

This course is designed for the TM1 power user to learn how to create and own ad hoc analysis and reports. 

Day 1

  • Overview of TM1 and Multidimensionality
  • Introduction to TM1 cube and database structure
  • TM1 Browsing and database query interfaces and all core features and functions
  • Creating and modifying Excel reports that are interactive with the TM1 database

Day 2

  • Using TM1 worksheet formulas in multifunction worksheets
  • Dimension access functions
  • Worksheet functions that control the appearance of data and information
  • Excel tools used to restrict or focus access to the database
  • Selective automation of column and row data in a TM1 report (via Dynamo! or active forms)
  • Functions that allow selective ad-hoc export of data from a cube into a delimited file
  • Selected Excel data analysis tools used in conjunction with TM1 functions
  • TM1 Active Forms creation, modification, and utilization  


TM1 Administrator - 1 day

This course is designed for ownership of maintaining and administering TM1.

  • Adding/modifying existing users and groups
  • Creating/modifying security definitions
  • Navigating TM1 configuration settings and log files
  • Using TM1 as a service


TM1 Developer - 2 days

This course is designed for those who want to learn how to create new cubes and calculations.

  • Creating cubes and dimension based on best practices and optimization techniques
  • Creating turbo integrator scripts to import data and update dimensions
  • Creating rules to calculate values within a cube and across multiple cubes


TM1 User Fundamentals, Developer & Administrator - 5 days

This comprehensive course is designed for the “do it all” TM1 user covering TM1 basics, administration and developer.

  • Day 1-2: TM1 User Fundamentals (see above course details)
  • Day 3-4: TM1 Developer (see above course details)
  • Day 5: TM1 Adminisrator (see above course details)
  • Save $200 on the complete course by taking this class all in one week