Cubewise EDU's August 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.
Classes will commence on August 3rd and be conducted over two half-days, allowing students to balance work and online studies.

Class Timing:
Australian Time Zone: 9:00 am to 1:00 pm AEST
European Time Zone: 8:00 am to 12:00 pm BST
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.

Interested in upskilling with multiple courses? Join the Power User Membership and enjoy the following benefits:
– An online ticket to Horizon, the global user conference on IBM Planning Analytics / TM1
– Exclusive access to the Power User Community, a dedicated space to share insights and interact with your peers who are also passionate about IBM Planning Analytics / TM1. 
– Access to 300+ EDU Video Library from Horizon and webinars
– Flexibility to attend online classrooms or self-paced learning for all our courses
– Extra insights on the course topics.

Email for more information.
We are excited to announce that the TM1py Fundamentals course can be learned through Self-Paced mode! This training style works best for those who can’t take much time off for upskilling and want to weave the lessons with day-to-day tasks. In addition, with this training style, you will receive 1 hour of one-on-one mentoring with a consultant.

It’s an ideal foundation for developing your own Python and TM1py scripts.

Lessons covered:
– Getting to know the TM1py package: interface and documents
– How to read TM1 data with Python
– How to update metadata and synchronize dimensions and hierarchies
– How to write data to TM1
– Dot the i’s and cross the t’s: Make your TM1py script production ready

How is it taught?
It is a self-taught course with 1 hour of mentoring.

What is the duration?
The course includes 10 hours of training server usage over 7 days. It can be completed in 8 hours.

When is it conducted?
You can start on any date that fits your schedule.

What resources are provided?
– Online course resources
– Training server
– Community Hub, a space dedicated to IBM Planning Analytics/TM1

Does the course include a digital badge?
Students can receive a digital badge to showcase their knowledge, which can be shared on LinkedIn or other professional networks.
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, Writing to TM1 with TM1py.

In almost every TM1py project it is necessary to write back data from Python into a TM1 cube.

TM1py offers different functions to write to cubes. There is not one ideal function to write back, but every function comes with its pros and cons.

Check out this insight, where the most essential functions are discussed with their unique characteristics and arguments.
We’re excited to announce that you can now buy your ticket for Horizon, our annual Global User Conference for IBM Planning Analytics/TM1, and join a vibrant global community dedicated to pushing the boundaries of knowledge in IBM Planning Analytics/TM1.

Join us on Tuesday, 17 October, for a day filled with unparalleled learning, networking, and knowledge sharing. As we enter the conference’s 4th year, we are committed to making this experience the most engaging and enriching one yet!

Let’s come together and create an unforgettable celebration of TM1 knowledge and collaboration at Horizon! See you there!  

Don’t miss your opportunity to influence the agenda! Submit your topic suggestions today.
Follow us on LinkedIn to get the latest news on the conference.

Please contact us at if you have any questions.
Workforce Planning often is a manual and time-consuming process where specific knowledge of a planner is required to create a feasible plan.

By combining a planning solution with decision optimization this process can be transformed into an efficient process where optimum planning is generated with a click of a button.

Watch Luc Cusiel‘s presentation from Horizon 2021 to learn more on:
– Improving Workforce Planning with Decision Optimization
– Creating A Linear Programming Model for Construction Planning
– Optimizing Construction Projects Using Decision Optimisation
– Maximizing Efficiency with Decision Optimisation: Exploring the Simplex Method

Improve your Workforce Planning with Decision Optimization, presented by Luc at Horizon 2021 

Meet Nimeesh, Head of Cubewise Care. Coming from a background in computer engineering, he embarked on his professional journey immediately after graduation, diving into the realm of Cognos. It was during this time that he first encountered TM1, and it was a revelation. Experiencing several “light-bulb” moments, he was astounded by the speed and agility of TM1.

In this captivating episode of “15 Minutes With..,”  Jon Lee engages in an insightful conversation with Anne-Marie Rodd, exploring her outstanding achievements at the first-ever TM1 World Championships 2022 held in Sydney.

Features that are new in IBM® Planning Analytics with Watson™.
Planning Analytics

Read about what’s new or updated in IBM® Planning Analytics and components that are installed with Planning Analytics, such as TM1® Server, TM1 Web, TM1 Performance Modeler, and TM1 Architect. Some updates affect only IBM Planning Analytics Local.
IBM® Planning Analytics Local version and the cloud release of IBM Planning Analytics version includes updates for IBM TM1® Server version 11.8.22.

IBM Planning Analytics version includes numerous improvements and defect fixes, but does not include new features.
Planning Analytics Workspace

Find out what’s new or changed in the most recent release of IBM® Planning Analytics Workspace. The new features described here always reflect the full capabilities of Planning Analytics Workspace on cloud.
What’s new in books and reporting – 2.0.89

Use the new Selector visualization in place of selector widgets in your books
In Planning Analytics Workspace 2.0.89, a new Selector visualization is available to replace selector list and selector tile widgets in books.

Pick lists now use the font defined for data cells in an exploration
In previous versions of Planning Analytics Workspace, pick list cell values and list members were displayed using the default IBM Plex font.

Resize books to fill space in a tab
You can now resize a book in a tab that contains the full width and height within different window sizes with the new Fill space feature.
What’s new in plans and applications – 2.0.89

Complete button for tasks that do not require submission
A Complete button is now available on the contribution page in tasks that do not require submission. Previously, if a task in a plan did not require submission, there was no way to indicate that the task was complete.
What’s new in modeling – 2.0.89

Synchronize user groups in Planning Analytics databases with Planning Analytics Workspace
 Administrators and modelers can now synchronize user groups that are in a Planning Analytics database with the groups in Planning Analytics Workspace from the modeling workbench.

Duplicate cubes in the cube viewer
The Duplicate button is now available on the cube viewer toolbar on the workbench.
What’s new in Deprecation notices – 2.0.89

Classic cube viewer to be removed from Planning Analytics Workspace 2.0.90
 As of Planning Analytics Workspace 2.0.90, the classic cube viewer will be removed from Planning Analytics Workspace.
Planning Analytics for Microsoft Excel

Read about what’s new or updated in IBM® Planning Analytics for Microsoft Excel.
IBM® Planning Analytics for Microsoft Excel was refreshed on July 17, 2023 to include fixes and the following notices.

Updates to each version of Planning Analytics for Microsoft Excel are cumulative. To see what was new in previous releases, see What’s new in Planning Analytics for Microsoft Excel.

Resolved – potential report integrity issue in IBM Planning Analytics for Microsoft Excel
As previously stated, IBM Planning Analytics for Microsoft Excel 2.0.89 includes a refined fix for the potential report integrity issue in Custom Reports and Dynamic Reports that was announced in 2.0.88.

Formula failure behavior improved to simplify error identification
Formula failure behavior was improved in Planning Analytics for Microsoft Excel 2.0.89 to make error identification easier.

Upcoming change notification – Planning Analytics for Microsoft Excel to default to WebView2
 IBM® Planning Analytics for Microsoft Excel will default to using Microsoft Edge WebView2 in an upcoming release. WebView2 allows Planning Analytics for Excel to be compatible with newer web standards and technologies.