Become a developer with our consultant-built IBM Planning Analytics/TM1 training

Learn essential tools and know-how with our comprehensive training program

Information

Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes.

Prerequistes

End User (Excel) course

What you will learn
  • The foundation to developing in IBM Planning Analytics/TM1
  • How to develop and and maintaining dimensions
  • How to create Cubes      
  • How to write Rules
  • How to setup security

Difficulty

Intermediate

Information

Learn the intricacies required to create dynamic reports in Excel. Choose either Perspectives or Planning Analytics for Excel.

Prerequistes

End User (Excel) course

What you will learn
  • How to export data into Excel, keeping the connection to TM1
  • How to snapshot data to Excel
  • How to building TM1 Excel Reports
  • How to use Active Forms / Dynamic Report
  • How to take advanced of the Dynamic Rowset
  • How to format an Active Form
  • How to use the TM1RPTVIEW Formula
  • How to set up report filters
  • How to integrate multiple Active Forms into Excel
  • How to set up a chart for an Active Forms
  • How to use Action Buttons
  • How to set up dynamic columns
  • Key Excel worksheet functions you should know
  • Best Practice Principles for Building Reports

Difficulty

Intermediate

Information

Take your knowledge of Rules to the next level by writing multi-cube logic and learning how feeders work.

Prerequistes

Developer Fundamentals course

What you will learn
  • The fundamentals for writing Rules
  • How to use Feeders
  • How to use operators
  • Key Rule functions you should know
  • How to use strings in a Rule
  • How to feed to and from consolidations
  • How to write advanced Feeders
  • How to reference data in another Cubes
  • How to write a currency translation rule
  • How to write a moving balance rule

Difficulty

Intermediate

Information

Learn how experts use TurboIntegrator to write code beyond the restrictions provided by the wizard.

Prerequistes

Developer Fundamentals course

What you will learn
  • The fundamentals on TurboIntegrator programming principles
  • How to understand Data Sources
  • How to use Variables
  • How to create and destroy objects
  • How to use the Prolog tab
  • How to use Parameters
  • How to build Views and Subsets
  • How to use the Metadata tab
  • How to use the Data tab
  • How to load data
  • How to use Bedrock processes

Difficulty

Intermediate

Information

Learn how to write basic to advanced MDX within TM1 and client applications such as PAW, PA for Excel and Apliqo UX.

Prerequistes

Developer Fundamentals and Advanced Reporting (Excel) courses

What you will learn
  • MDX syntax explained
  • How to use MDX in the Architect Subset Editor
  • How to use MDX in Architect TurboIntegrator
  • How to use MDX in PA for Excel and PAW subset editor
  • How to use MDX in PA for Excel Exploration Reports
  • How to use MDX in ARC subset editor and MDX tool
  • How to use MDX in TurboIntegrator MDX views
  • How to use MDX logging
  • Key supported expressions
  • How to use MDX to filter Cube data
  • How to use the ‘generate’ function
  • Do’s and Don’ts in MDX
  • How to use MDX in Apliqo UX

Difficulty

Intermediate

“The [Cubewise EDU Planning Analytics/TM1 Developer] courses were structured in a logical manner that made sense .”

Catherine McCormack
Business Analyst

Choose to attend one of many scheduled classroom training sessions globally

Share your know-how with the Skills Acknowledgement

Complimentary to each course, achieve a personalised digital badge that you can proudly share on LinkedIn.

Students who have received a Cubewise EDU skill acknowledgement have proven they have attended class and received 100% on class assessment.


We offer three methods of training styles to match how you want to learn

Self-development is key to mastering IBM Planning Analytics/TM1, and we want to help you reach that goal


Select the Membership Plan that suits you, to begin your training program


Want to verify your TM1 Developer knowledge to potential employers?

Independently verify your knowledge and get ahead in the industry with the TM1 Developer Credential. Validate your value and worth by sharing your achievement on LinkedIn.


Stay in the loop

Keep yourself informed on the latest news in the analytics space by following us on LinkedIn.

For any enquiries, email us at edu@cubewise.com or contact an office near you (link).