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 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 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!


    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 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 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 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

    Single cell widget is now a visualization type
    The single cell widget is now a visualization type and has several new capabilities. You can create a single cell visualization and convert it to a view (exploration) or another visualization and vice versa.

    Align cells and headers
    You can now align the text in data cells and headers in an exploration (view) and a single cell visualization.

    What’s new in plans and applications – 2.0.81

    Use rich text formatting in plan and application descriptions
    You can now apply rich text formatting to enhance your plan and application descriptions.

    Task flow view in plans
    You can now manage plan tasks by using the task flow view.

    What’s new in administration – 2.0.81

    Include plans and applications when you copy and deploy assets with Lifecycle Management
    You can now include plans and applications when you create and deploy a snapshot in Lifecycle Management.

    What’s new in modeling – 2.0.81

    Updated ‘Import members’ procedure
    As part of our continued investment in the IBM Carbon Design methodology and in the interest of providing a consistent user experience across all components, the Import members procedure for a dimension has been updated to use Carbon Design principles.

    Snippets in the process editor
    The process editor in Planning Analytics Workspace provides predefined code snippets that users can insert in the TurboIntegrator process.

    Deprecation notices – 2.0.81

    Deprecation notice – the set editor in a widget is removed from books as of Planning Analytics Workspace 2.0.81
    You cannot add a set editor in a widget from the Data tree in books as of Planning Analytics Workspace 2.0.81.
    Planning Analytics for Microsoft Excel

    Read about what’s new or updated in IBM® Planning Analytics for Microsoft Excel.
    In a future release of Planning Analytics for Microsoft Excel, IBM will expand the formula failure behavior to simplify error identification. #VALUE errors will denote incorrect formula construction, including bad input type. #NUM errors will specifically represent a numeric error in a formula. A #NUM error could mean that the input(s) are not in the range of valid metadata. Currently, all formula failures show #VALUE, which can be an ambiguous Excel error indicator.

    New TM1SET function supports alternate hierarchies
    TM1SET, a new worksheet function that supports alternate hierarchies, is now available in IBM Planning Analytics for Microsoft Excel and IBM Planning Analytics TM1 Web. Until now, functions in both Planning Analytics for Excel and TM1 Web only supported default hierarchies.
    What’s new in TM1 Web

    There are new features in IBM® TM1® Web. For more information, see the TM1 Web documentation inIBM Knowledge Center
    Aligning releases for IBM Planning Analytics components
    To simplify and align IBM Planning Analytics TM1 Web (Spreadsheet Services) releases with those across IBM Planning Analytics Workspace, IBM is labeling its next TM1 Web release as IBM Planning Analytics TM1 Web 2.0.81.

    New TM1SET function supports alternate hierarchies
    TM1SET, a new worksheet function that supports alternate hierarchies, is now available in IBM Planning Analytics for Microsoft Excel and IBM Planning Analytics TM1 Web. Until now, worksheet functions in both Planning Analytics for Excel and TM1 Web only supported default hierarchies.

    Set editor available for TM1SET function in websheets
    The new TM1SET function in TM1 Web websheets supports the IBM Planning Analytics Workspace set editor. Previously, set editor integration was not supported in websheets.

    Export dialog includes hierarchy name for TM1SET functions
    When you export a websheet in TM1 Web (slice to Excel), the Export dialog displays the hierarchy name in the title dimension for TM1SET functions.

    Related content

    Loading related content