Cubewise EDU's November Newsletter

Check out what's happening in the world of IBM Planning Analytics, and harness our focus and enthusiasm to your benefit in one or more ways!

Upskill your know-how on IBM Planning Analytics/TM1, through our consultant-led training.
Get ready for an enriching learning journey starting on November 6th! Our classes are structured with convenience in mind, spanning two half-days, allowing you to seamlessly balance your work commitments with your online studies.

Class Timing —
Australian Time Zone: 9:00 am to 1:00 pm AEDT
European Time Zone: 8:00 am to 12:00 pm GMT
End User (Excel)
Learn how to explore data, become proficient in analysis, and discover various reporting possibilities in Excel. Choose between Perspectives or Planning Analytics for Excel.

Advanced Reporting (Excel)
Learn the intricacies required to create dynamic reports in Excel. Choose Perspectives or Planning Analytics for Excel.

End User (PAW)
Explore data analysis, hierarchy utilisation, and dashboard creation for the web using Planning Analytics Workspace (PAW).

Check our website for more details on each course.

For any additional information or inquiries, feel free to reach out to us via email at We’re here to help you make the most of your learning journey!
The Power User Membership offers a unique opportunity for professional growth, providing you with a solid foundation to elevate your knowledge and explore new possibilities in the world of IBM Planning Analytics/TM1. This membership package includes:

Video Hub: Gain access to a vast video platform featuring over 400 presentations from past conferences and webinars. The audio is transcribed, making it effortless to find the content you’re seeking.

Training: Our comprehensive training pathway equips you with the skills and knowledge to drive your organization forward. Our training courses are updated annually to ensure they remain relevant. 

The Power User membership grants you access to all courses and offers two training options: 
– Self-paced learning with 1-hour mentoring sessions from an expert.
– Join one of our scheduled online classroom sessions, available in Europe and Australia.
Newly added: We recently introduced training in Mandarin, providing even more accessibility and flexibility to our global members.

Post Training Insight: Learning never ends with Post Training Insights! We are always learning new and different ways to use the tool and will share these tips with Course or Power User Members. Post Training Insights are appended at the end of the course.
EDU Induction sessions, are designed to help you maximise the benefits of our educational content. These sessions will equip you with the knowledge and tools necessary to make the most out of your membership.

Session Schedule:
Induction sessions are conducted fortnightly to accommodate various schedules. We highly recommend that all students attend at least one induction session to get started on the right foot.

What to Expect:
– Discover the numerous benefits included in your membership.
– Explore the Community Hub and learn how to connect with fellow learners.
– Navigate through our Video Hub, where you can access a wealth of informative content.
– Get step-by-step guidance on how to start your learning journey.
– Stay updated on upcoming events to enhance your educational experience.
– Participate in a Q&A session to clarify any doubts you may have.

Please mark your calendars for the upcoming sessions and feel free to attend the one that suits you best.

Looking forward to seeing you at the next Induction session!
We are excited to release the TM1py Post Training Insight, Synchronizing hierarchies with TM1py.

The Problem
In large organizations that employ IBM Planning Analytics (TM1) for years, you often find multiple dedicated smaller TM1 instances (= models) instead of one monolithic TM1 model used by everyone in the organization.

Having multiple TM1 instances is not a problem in itself. In fact it helps in many ways:
– scaling models horizontally over multiple machines ensures more resources (CPU, RAM) per instance and better performance for end-users
– reduces restart times and guarantees local impact of a (god forbid) server crash
– it helps with separation of concerns and laying our responsibilities from a development and admin perspective

However, laying out your TM1 environment “horizontally” comes with unique challenges.
– You need to guarantee that certain shared hierarchies are in sync. For instance, there must only be one CoA rollup in the organization.
– Especially shared dimensions that are edited by power users within TM1 can be challenging

The Solution
TM1py makes it easy to spot differences and synchronize dimensions between TM1 instances. Here is a sample that determines if a dimension is in sync in 6 lines of code.
After an exhilarating 25 hours of Exploring New Perspectives together, Horizon 2023 has now come to an end! Here’s a glimpse of our incredible journey:

💡 113 captivating presentations in 25 hours!
💡 Engaging sessions in English, Mandarin and French.
💡 A remarkable lineup of 97 presenters from across the globe.
💡 Enthusiastic participants from 32 countries.
💡 An unforgettable networking and knowledge-sharing event!

To all the remarkable participants of Horizon 2023, thank you for joining us. Horizon begins on:
We want to express our sincere appreciation to all our presenters for contributing to the resounding success of Horizon 2023.
A special thanks goes out to Tansel Ali, this year’s keynote speaker, who took us on an unforgettable journey into the world of memory mastery.

If you missed out on the action – you’re in luck! You can still register for the Standard Online Pass, which grants you access to over 90 recorded presentations and the Video Hub, featuring hundreds of presentations by experts, consultants, customers, and IBM from past events.

If you have questions, feedback or simply want to continue the conversation, please reach out to us at

Thank you once again for being part of Horizon 2023. Here’s to continued learning, growth, and community building in the world of Planning Analytics/TM1!

Meet Renato, Cubewise Consultant. With a background in business and finance, his introduction to TM1 came during an internship at a pharmaceutical company. Since then, he has been captivated by the possibilities TM1 offers and holds great hope for its enduring future.
In this episode of “15 minutes with..” Jon Lee sits down with Marius Wirtz, the mastermind behind TM1py.

Jon delved into Marius’s TM1 journey, and this time, the spotlight wasn’t on TM1py, for which Marius is widely recognized. Instead, it was an opportunity to discover Marius’s initial introduction to TM1, what initially piqued his interest in the platform, and how this led him down the path to creating TM1py. This episode has something to offer for everyone, whether you’re a TM1 enthusiast or simply curious about Marius’s TM1 journey. We hope you thoroughly enjoy the video.