We are excited to bring back Horizon, the biggest knowledge sharing event dedicated to IBM PA/TM1 that comes around once every year for the community!
Agenda out now!!! 🎉
Consultants and companies from all over the world will share: ✅ Tips and Tricks discovered ✅ Insights on new features ✅ Customer success stories
New presentations added to the agenda weekly!
By attending Horizon, within just 24 hours, you will acquire new IBM Planning Analytics/TM1 knowledge and skills to put into practice immediately from the vast knowledge shared across the globe.
We are complementing Horizon with in-person events in Melbourne and Sydney.
– Deep dive into topics from Horizon in an intimate setting – Workshop topics you want to know more about – Gain hands-on experience in mini-training sessions to learn about a product – Network with your peers.
Save the date!
Horizon, Tue 18th October at 9:00am AEDT Horizon Sydney, Tue 25th October at 9:00am Horizon Melbourne, Thu 27th October at 9:00am
The early bird price is valid till 30th September, so head over to the Horizon page to check the agenda and secure your ticket today!
Our Horizon presentation of the month is … A Solution for Consolidated Forward Weeks of Cover🎉🎉🎉
This presentation explores a solution used to ascertain a Forward Weeks of Cover calculation at different consolidated levels from source planning data by the Cotton On Group, a retail organisation that operates across many countries and brands.
Check out what Errol Grey, Enterprise Reporting Lead at Cotton On Group, has to share.
Measure your advancement with a well-mapped learning pathway.
Are you new to IBM Planning Analytics? These are the end-user courses we recommend, in this order.
End User (Excel) – Learn to explore data to be a proficient analyser and get to know all the reporting possibilities in Excel. Choose 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 how to analyse data, utilise hierarchies and create dashboards for the web, using Planning Analytics Workspace (PAW).
If you have already completed our end-user courses or have experience with IBM Planning Analytics/TM1 , continue your upskilling with these developer courses. Our recommended order is shown below.
Developer Fundamentals – Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes. Advanced TurboIntegrator – Learn how experts use TurboIntegrator (TI) to write code beyond the restrictions provided by the wizard. Advanced Rules – Learn how to write multi-cube logic and clearly understand how feeders work to ensure an efficient model. Advanced MDX – Learn how to write advanced MDX within TM1 and client applications such as PAW and Planning Analytics for Excel to control the data received. TM1py Fundamentals – The ideal foundation to get you started with developing your own Python and TM1py scripts. Pulse Fundamentals – Learn the functionalities that comes with Pulse such as live monitoring, user analytics, Excel analysis, documentation, migration and proactive alerts. Apliqo UX Fundamentals – Learn how to create a modern, curated web experience for your IBM Planning Analytics/TM1 users.
“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.”
Exclusive to members, 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, provide updates on upcoming events and open the floor for your questions.
Please RSVP for the session that suits your schedule:
– Tue 6 Sep @ 8:00am London – Tue 6 Sep @ 9:00am CEST – Tue 6 Sep @ 3:00pm Hong Kong – Tue 6 Sep @ 5:00pm Melbourne/Sydney
– Wed 7 Sep @ 8:00am Melbourne/Sydney – Tue 6 Sep @ 3:00pm, San Francisco – Tue 6 Sep @ 5:00pm, Dallas – Tue 6 Sep @ 6:00pm, New York
Interested in joining the Power User membership? Reach out to email@example.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.
We carry on our Lightbulb Files series — this time around with Sreenivas Tata, Cubewise’s General Manager for Australia’s Southern Region.
2021 has been a hard year for business. But the plethora of financial and operational challenges companies faced this year also provided plenty of opportunities to reflect, learn, and grow
In the 2022 instalment of Jack’s masterclass series, we’ll take a bird’s eye view at some of the key learnings from our previous masterclasses, as well as the lessons we learned as we navigate the murky waters of FP&A post-COVID-19.
– March 17: The Ultimate Value Drivers: Growth and Return on Invested Capital (ROIC) – April 28: Planning and Analysis for Critical Value Drivers, Part 1: Growth and Profitability – June 9: Planning and Analysis for Critical Value Drivers, Part 2: Asset Management – July 21: Strategic Analysis and Planning – September 1: The External View: Benchmarking Performance and Competitive analysis – October 13: Developing Predictive and Analytical Models
A new version of Arc and Slice is now available to download. v3.4 includes many new exciting features.
– Easily apply standard practices with the code formatter – Expand Above in subsets and cube views – Quickly see and clean your applications – Easier to troubleshoot your MDX – Export MDX Forms from a cube view
and much more…
A complete list of all enhancements and fixes can be found in the Arc & Slice v3.4 Release Notes (v3.4.0.md).
Try Arc & Slice now!
Arc & Slice are free to download and includes a three-month “no strings attached” trial license.
It’s safe to say that we’ve never before seen the scale of widespread cash injections that we saw during the COVID-19 pandemic. Governments across the world scrambled to print the money they needed to keep the economy afloat and provide the support that their citizens needed. The natural consequence of this has been rapid inflationary pressures (Blog).
One of the most important knock-on effects of increasing inflation is the natural response that we have seen in interest rates. In an attempt to control monetary supply, we’ve emerged from a decade-long period of low interest rates – and into one where they seem to keep rising and rising.
As a company, it’s important to assess how these interest rate changes will affect your business and the best way to do this is by utilizing your FP&A tools to their full potential.
Have you ever wondered what happened in your applications in the last few minutes? Or even over the last few days? Perhaps you want to know who was logged in this morning or how much memory was used last night. All of these questions can help you get a better understanding of how your IBM Planning Analytics (TM1) system is being utilized.
And all of the answers can be found with Pulse.
Pulse tracks everything that is happening across all your IBM Planning Analytics (TM1) applications (on-premise or on PA SaaS) and it stores this information in a powerful database that is built to handle large amounts of data.
Let’s have a look and see how this can help you.
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.
Use the new interface to manage chores involved with a specific process Previously, when you opened the context (right-click) menu for a process in the Databases tree, you could click the Display chores involved option to open the Modify chores window. This window listed all of the chores that included the process. You could then use the Modify chores window to edit selected chores that included the process or delete the process from selected chores.
Select multiple variables in the process editor You can now select multiple variables in the process editor. When multiple variables are selected, you can apply any option on the selected variables bar to multiple variables simultaneously.
Go to a specific line in the process editor You can now jump to a specific line in the process editor with Go to line. This capability was previously available only in the rules editor through shortcut keys (Ctrl + L or Cmd + L). Now, you can click the Go to line icon in both the rules and process editors to quickly move up and down the script. This feature is especially useful if you encounter a process error that requires you to go to a specific section and line number.
Apply formatting to visualization axis When you apply formatting to a visualization axis now, the axis retains the format when you change the member on the axis or when synchronization automatically changes the member. The formats are also retained when you switch from one visualization to another or convert the visualization to an exploration and vice versa.
Wrap text in data cells You can now format string cells in explorations (or views) to wrap text. You can wrap multi-line text in data cells with or without line breaks. Previously, you could only wrap text in headers.
Aligning releases for IBM Planning Analytics components To simplify and align IBM Planning Analytics for Microsoft Excel releases with those across IBM Planning Analytics Workspace, IBM is labeling its next Planning Analytics for Excel release as IBM Planning Analytics for Microsoft Excel 2.0.79.
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.79.
Location detail for SUBNMs included in the TM1 Web Export dialog In TM1 Web, when you export a websheet (slice) to Excel, you can now see the location details for any cell that contains SUBNMs in the websheet. The location details appear in the Export dialog and along with the sheet name, includes the row and column number of the SUBNM. This makes it easier to identify SUBNMs and determine which SUBNM is driving the report based on its position. Previously, if there were multiple SUBNMs in a websheet with the same dimension name, it was difficult to identify the SUBNM when exporting.
Authentication enhancement for websheets in IBM Planning Analytics Workspace You no longer see an authentication error when you open a TM1 websheet with data from multiple databases in Planning Analytics Workspace. Instead, an authentication page now displays for each database that is referenced in the websheet. Simply enter your credentials to open the websheet. This enhancement eliminates the need to manually resolve the authentication error, saving you time and effort.
Known issues The following are known issues in IBM Planning Analytics TM1 Web. These issues will be resolved in a future release.