Nov 1, 2022
Cubewise EDU’s November Newsletter

Horizon, the biggest knowledge-sharing event dedicated to IBM PA/TM1wrapped on the 19th of October.
– 120+ presentations over 25 hours!
– Dedicated sessions in English, French and Mandarin
– 108 Presenters from around the world
– Attendees from 32 countries
– AMAZING knowledge sharing event!
As always, our presenters did an outstanding job of sharing their expertise. Well done to everyone involved in making this event a success and thanks to all who attended!
Missed out? You can still register for the Horizon Online Pass to watch recorded presentations and connect with peers through the Cubewise EDU Community Hub.
Head over to our website to find out more information.
Reach out to horizon@cubewise.com if you have any questions.

We did it! On the 25th of October in Sydney, Australia the first ever TM1 World Champion was crowned – congratulations to Dwight Smith!
It was definitely an intense competition; hard-fought to the very end. We started with 74 participants in the first round and witnessed a true Ali vs Frazier level epic battle in the final round between Dwight and Anne-Marie Rodd.
The order of finish for the legends that made it to the final Thunderdome round:
1. Dwight Smith
2. Anne-Marie Rodd
3. Peter Choi
Well done and thank you to everyone who participated!
Many were asking beforehand if they would be able to watch the TM1 World Championship remotely, but it was live-only for the people there on the day.
HOWEVER! We did put this highlight package together, which we hope the global TM1 community will enjoy!

Classes run bi-monthly in Australia and every quarter in Europe.
Next online classroom commences on 15th November, in the Australian time zone.
Nov 15 – Pulse Fundamentals
Nov 16 – Advanced Rules
Nov 22 – Advanced MDX
Looking to upskill in more than one course? Join the Power User Membership and gain access to ALL our courses!
Email edu@cubewise.com for more information.

“This training has exceeded my expectation, I knew nothing at all about tm1py and by the end of 4 sessions. I was able to download TM1py, connect to TM1, load data, run a TI process, and add a new element plus the attribute using TM1py script!
So happy that I registered for this course. Marius Wirtz is really the best TM1py trainer, he always makes sure that all the participants have time to ask questions, and if we are stuck or get an error, he will help us to tackle it during the training session.
I would highly recommend anyone who wants to learn TM1py from the beginning to join this course!
10/10
Thanks again to the Cubewise training team for organising this.”
– Ivonne Wijaya, Group Management Accountant at GHD
We could not be more pleased with this amazing testimonial. Thank you, Ivonne!
Would you like to kickstart your knowledge using TM1py?
Classes run every quarter. Register your interest to join the next class commencing on 2nd February 2023 in the Australian and European time zone.
Head here for more information.
Reach out to edu@cubewise.com for more information.

We are excited to release the Apliqo UX Fundamentals Post Training Insight: Advanced UX Techniques
Learn how you can design an advanced web application using IBM Planning Analytics as the back end and Apliqo UX as the front end.
Reach out to edu@cubewise.com if you have any questions.

New to the Power User membership, we have created an exclusive community with like-minded peers.
It’s a dedicated space to share insights, access to exclusive presentations, opportunities to network, engage with each other, and share meaningful conversations.
This week, we have organised two meetings to welcome our members, talk about the key features of your membership and this group, and open the floor for your questions.
Please RSVP for the session that suits your schedule:
Session 1
– Tue 8 Nov @ 8:30am Melbourne/Sydney
– Mon 7 Nov @ 1:30pm, San Francisco
– Mon 7 Nov @ 3:30pm, Dallas
– Mon 7 Nov @ 4:30pm, New York
Session 2
– Tue 8 Nov @ 8:00am London
– Tue 8 Nov @ 9:00am CEST
– Tue 8 Nov @ 4:00pm Hong Kong
– Tue 8 Nov @ 7:00pm Melbourne/Sydney
Interested in joining the Power User membership?
Reach out to edu@cubewise.com with your questions.

In an attempt to illustrate our deep passion for IBM Planning Analytics / TM1, our Control CC team asked Cubewisers what was their lightbulb moment.
Business complexity outgrowing spreadsheets is something we’ve heard a few times. Joseph Pusztai shares his own IBM Planning Analytics / TM1 story in the latest episode of the lightbulb files.

The Apliqo team has been producing webinars that are pertinent to the FP&A community since 2013.
They make this content available to everyone on-demand as a way of propelling FP&A best-practices forward.

In June 2022, Ben Heinl and Jason Tranfield had the chance to reunite the original Sinper developers hired by the late Manny Perez.
In this interview, learn how TM1 came to be and how it developed under the close eye of its creator through first hand stories of his crew: Yu Zou, Jose Vazquez and Roger Torres.
Our Control CC team broke down this interview into 7 episodes. We hope you enjoy it.

Every IBM Planning Analytics (TM1) developer will be familiar with the tm1server.log – a file that contains important details about activity including executed processes, chores, loaded cubes, and much more…
However, when you are working with many different TM1 instances, it can be somewhat cumbersome to open several different tm1server.log files from different folders in order to understand what happened in your various applications. Too often, developers will end up with multiple files open and a lot of frustrating experiences digging in Notepad++.
Thankfully Pulse comes with stunning visualizations that are not only aesthetically pleasing but also very user-friendly. These help you to quickly understand what happened across all your servers without going through the tedium of opening different log files. In this way, Pulse can save you a lot of time and you will be able to spot potential issues that may have gone unnoticed.

Since its first release in 2016, TM1py has now established itself as the most popular scripting framework for IBM Planning Analytics (TM1). Most things that you can’t do out of the box with TM1 you can do easily with Python and TM1py. TM1py makes TM1 works like a charm with Python.
Over the years TM1py has become mature and robust and is now used in many TM1 applications all around the world. Version 1.10 takes TM1py another step further by adding additional optimisations and new utilities.

Imagine for a second… You are in the month-end process and once again you need to execute the processes calculating the allocation during working hours. Do you know how long this process is going to take to complete? Maybe you also need to schedule a new chore – is it easy to find a free timeslot between two chores?
In this article, the Code team will walk you through how Pulse can help with these two scenarios.

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.
SubsetMDXSet function extended to apply to temporary subsets
The SubsetMDXSet TurboIntegrator function, which applies a specified MDX expression to a subset, has been extended to apply to temporary subsets.
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 Planning Analytics Workspace Local – 2.0.81
Configuration support available for Red Hat OpenShift Service Mesh in Planning Analytics Workspace Distributed
You can now enable Service Mesh support in IBM Planning Analytics Workspace Distributed. You can configure Planning Analytics Workspace Distributed to use Service Mesh if OpenShift Service Mesh was enabled for your cluster.
What’s new in books and reporting – 2.0.81