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).
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book demo
