May 1 2023
Cubewise EDU’s May Newsletter 2023
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!
The annual training course refresh has been completed for the courses below.
– End User (PA for Excel)
– Advanced Reporting (PA for Excel)
– Advanced MDX
– Pulse Fundamentals
Interested in upskilling your knowledge? Register Today!
Upskill your know-how on IBM Planning Analytics/TM1, through our consultant-led training.
Classes commence on May 10, in the Australian and European time zone.
Duration: Course covered over one full day.
– Australian Time Zone: 9:00am to 5:00pm AEST
– European Time Zone: 8:00am to 4:00pm BST
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.
EDU Induction sessions, enable members to make the best use of the educational content we have to offer.
We will go through:
– Benefits included in your membership
– Walkthrough of the Community Hub
– Walkthrough of the Video Hub
– Steps to follow when you are ready to commence training
– Upcoming events
– Q&A
Sessions are conducted fortnightly.
We recommend all students attend an induction. Please RSVP to a session that fits your schedule.
Email edu@cubewise.com for more information.
We are excited to release the Advanced Rules Post Training Insight, Advanced Rules Calculation
Step-by-step demonstration of implementing some business requirements using advanced rules calculation techniques.
Reach out to edu@cubewise.com if you have any questions.
Learn about new and existing features that TM1py has to offer for TM1, shared by Marius Wirtz.
He will go through a range of common challenges and illustrate how TM1py can be used to solve concrete problems, such as:
– Integrating TM1 with cloud systems (e.g. Workday, NetSuite, Salesforce)
– Automating manual processes for TM1
– Leveraging Python’s AI capabilities for TM1
Are you interested in upskilling your knowledge of TM1py?
Register for our upcoming TM1py Fundamentals training this month.
The ideal foundation to get you started with developing your own Python and TM1py scripts.
Lessons:
– 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
Email edu@cubewise.com with your questions.
Congratulations to Cristian B., the new TM1 World Champion! He had nerves of steel that carried him to the win over the reigning champ Dwight Smith at the IBM Innovation Studio in London.
With the second TM1 World Championship under our belt, we now have a new TM1 World Championship World Ranking:
- 1. Cristian B.
- 2. Dwight Smith
- 3. Paul Segal
- 4. Anne-Marie Rodd
- 5. Bruce Moyes
- 6. Peter Choi
- 7. Garima Singh
- 8. Warwick storey
- 9. Alin Ciochirdel
- 10. Audrey Jackson
- 11. Eddie Medina
- 12. Mohit Gupta
- 13. Jarrod Rodney
- 14. Leslie Bogdan
- 15. Michael Herring
- 16. Kevin Murphy
- 17. Douard Le Roux
- 18. Adam Buckle
- 19. Daniel Peeroo
- 20. Grantham Good
- 21. Ian Digby
- 22. Peter Warren
- 23. Jerome Adams
- 24. Finn Hoile
- 25. E-J Goode
- 26. Alain Ho
- 27. Nils Kirchhübel
- 28. Dirk Reitinger
- 29. Julian Hegedus
- 30. Tolga Cucen
- 31. Pramod Krishnamurthy
- 32. David Wise
At this free event, exclusively for companies who have purchased or are considering purchasing IBM PA/TM1, we will share the latest news in our industry and provide our candid take on it all. Then stay afterward to connect with your peers over drinks and canapés.
1:30 pm – Registration
2:00 pm – Presentations commence (more information to come!)
5:00 pm – Networking over drinks and canapes
Get your complimentary ticket today!
Meet Nadia Ramtani, Cubewise’s Practice Manager for France. With a professional experience of 20 years of TM1, Nadia is constantly looking for the next challenge she can solve with TM1. This is her story.
In any large organisation, decision-makers rely on reports to give them the information they need for strategic conversations and decisions. The numbers are the foundation of goal setting, budgeting, forecasting, product development, sales strategies, and so much more. The more you can rely on your numbers, the better decisions you are able to make.
However, numbers can be fickle. While they seem to be entirely objective from the surface level, the truth is much more complicated than that. If you take figures at face value without understanding the underlying context and choices and compromises that went into producing the report – then those assumptions and biases are simply baked in, and you’ll never have a true understanding of what the numbers are saying.
With this release, TM1py closed the performance gap between TM1py and Turbo Integrator. Thanks to @AndrewScheevel, @Kevin Dekker and @Felipe Fonseca for contributing code!
The Code team encourages everyone to upgrade existing implementations that benefit from improved write speed.
All new features are backward compatible and all upgrades should be pain-free!
When Apliqo UX was built the team was on a mission to transform the interface of FP&A tools and bring a consumer-focused perspective to the data we were visualising. It’s long been their belief that merely having the data available for analysis is not valuable unless it is presented in a way that people can act on.
As storytelling creatures, bland spreadsheets and reports don’t really speak to us and so we risk losing out on all the value in our financial and operational information if we cannot find a way to present it both impactfully and functionally to our users. That’s why the Apliqo team focused a lot of their development efforts on crafting some powerful and unique tools for report builders so that they can tell their financial story with gravitas – in order to shift the narrative and persuade management decision-makers to take action.
Accurate forecasting is a severely underrated skill in modern business and one that you should be looking to improve if you want to maximize the value of your planning and analytics. But the only way to do this is to have a feedback loop where you can look back on the forecast methodologies that you used in the past and assess how they fared when coming up against the uncertainties of the real world.
It’s for this reason, that a forecast post-mortem can be such an eye-opening component of your FP&A journey.
Check out the article to learn :
– What is a forecast post-mortem?
– Preparing for an effective forecast post-mortem
– What should you be looking for during a forecast post-mortem?
Features that are new in IBM® Planning Analytics with Watson™.
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.86
Synchronise same hierarchies across different databases
You can now synchronise same hierarchies that are in different Planning Analytics databases.
Disable select data spreading methods on Planning Analytics Workspace Local
You can configure your Planning Analytics Workspace Local environment to disable any combination of the Repeat, Repeat leaves, Equal leaves, and Straight line data spreading methods.
What’s new in plans and applications – 2.0.86
Duplicate tasks and sections in Plans and Applications
You can now duplicate tasks in Plans and sections in Applications to quickly create similar tasks and sections, saving you time.
New look and usability improvements for Plans Overview
In Planning Analytics Workspace 2.0.86, the Overview tab in Plans features a new design and several usability improvements that help you quickly see your plan’s progress.
What’s new in modeling – 2.0.86
Git repository integration for Planning Analytics database objects
Modelers can now access a Git repository (GitHub, Microsoft Azure, or AWS CodeCommit) directly from Planning Analytics Workspace. You can use the Git repository to store Planning Analytics database objects such as cubes, dimensions, rules, and processes that are common across multiple models. You can also use the repository to move database objects from one environment to another. For example, you might want to copy database objects from a development environment to a production environment.
Dimension editor search and locate in hierarchy
You can now determine a member’s location using the dimension editor search function.
Hide databases in Preferences
You can now hide databases from the Databases tree on a modeling workbench.
Upcoming change notifications – 2.0.86
The following changes are planned for an upcoming Planning Analytics Workspace release. These notifications are made available so you can plan upgrades and maintain your Planning Analytics Workspace environment.
Upcoming configuration modification required for Learn Pane in Planning Analytics Workspace Local
The cognitive Learn Pane in Planning Analytics Workspace Local will be hosted on a new domain in the near future. This will require configuration changes to Planning Analytics Workspace Local installations to ensure continued access to documentation and other information through the Learn Pane.
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 April 10, 2023 to include the following features and 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.
New TM1ACTIVESERVERS function returns active connections
A new worksheet function, TM1ACTIVESERVERS, is available in IBM Planning Analytics for Microsoft Excel 2.0.85. TM1ACTIVESERVERS returns the host URI, server name, and username information for active session connections in a 2-dimensional array
DefineCalc function promoted from Technology Preview Code to production status
The worksheet function DefineCalc
is now available for production with core Custom Reports. DefineCalc
was introduced in IBM Planning Analytics for Microsoft Excel 2.0.80 as Technology Preview Code.
What’s new in TM1 Web
There are new features in IBM® TM1® Web. For more information, see the TM1 Web documentation in IBM Knowledge Center.
IBM® Planning Analytics TM1 Web was refreshed on 11 April 2023 to include fixes only.
Updates to each version of TM1® Web are cumulative. To see what was new in the previous release, see What’s new in TM1 Web.