Cubewise EDU, the place to upskill your know-how on IBM Planning Analytics/TM1!
Next session will be conducted in July 2022 in the Australian and European time zone. Spots are limited, so get in quick!
🌏 Australian Time Zone: 9:00am to 5:00pm AEST 🌏 European Time Zone: 8:00am to 4:00pm BST
July 12 – End User (PAW) July 13 – Apliqo UX Fundamentals July 14 – End User (Perspectives) July 14 – End User (PA for Excel) July 15 – Developer Fundamentals July 19 – Pulse Fundamentals July 20 – Advanced Rules July 21 – Advanced TurboIntegrator July 22 – Advanced Reporting (Perspectives) July 22 – Advanced Reporting (PA for Excel) July 26 – Advanced MDX
May sessions in Australia and Europe sold out fast. If you want to kickstart your knowledge using TM1py, enrol for the August session today!
📢 Classes will be held online. 📢 Class will run every quarter and commences on the first week of the month. Attend four 2-hour sessions over 4 consecutive weeks. 📢 Achieve a personalised digital badge that you can proudly share on LinkedIn by getting your knowledge endorsed. 📢 Monthly open forum scheduled after the course, for course members to engage with an expert on TM1py and go through any questions.
Grouping Option – Control how repeated elements on the row set appear in an Exploration or List. Because an element appears in each row for ‘Repeated labels’, this options works best if you want to do a lookup like an xlookup.
The Horizon presentation of the month is 🥁🥁🥁 … 10 Tips for More Efficient Development using Arc, presented by Tim Ryan 🎉🎉🎉
Arc is the ultimate tool to make TM1 easier and quicker to master.
– Arc can be used in Excel – Create a new object using a template – Set up a snippet to reuse code – Insert variable placeholders in a snippet – Shortcut keys like ALT+[Arrow Key] to flick between tab, CTRL+/ to toggle comments, CTRL+ALT+k to select all the strings – Replicate the security from an existing user for a new user – Impersonate a user to troubleshoot – Create a text output with parameters and/or variables included – Upload a file to the TM1 Server that can be used as the data source – Pin tabs to keep them available all the time
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.
Planning and Analysis for Critical Value Drivers, Part 2: Asset Management, scheduled for June 9. Register today!
📅 2022 FP&A Masterclass content calendar
– 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 TM1py is now available to download from the TM1py project on GitHub.
Iterative JSON parsing: The way TM1py retrieves values has been optimized using iterative JSON parsing. By using this technique, TM1py requires a significantly smaller memory footprint at an almost negligible cost of performance.
Skip non updateable cells: This optional argument to the write/write_dataframe functions asks TM1py to filter out cells that can not be updated before attempting to write. If not used, TM1py will fail with an error when attempting to write to rule-derived or consolidated cells. This is very helpful, as it saves the TM1py user from verifying the validity of the cell updates when not working with flawless data sources.
Search: New search functions have been added to each object.
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 126.96.36.199 and the cloud release of IBM Planning Analytics with Watson™ version 188.8.131.52 includes updates for IBM TM1® Server version 11.8.12.
IBM Planning Analytics with Watson version 184.108.40.206 includes numerous improvements and defect fixes, but does not include new features.
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.
Update to predictive forecasting service Predictive forecast capabilities in Planning Analytics Workspace use a common library of capabilities based on IBM Watson. In this Planning Analytics Workspace release, this library has been updated to support additional capabilities such as outlier detection and correction.
Adjust for outliers in your forecast If outliers are detected in your forecast, you can now use an option to adjust a forecast preview to compensate for the outliers and improve the accuracy of your forecast.
Changes to cube creation As of Planning Analytics Workspace 2.0.75, you can no longer create a cube from the Data tree in a book.
Add variables in the Process editor Up until now, the number of variables in a Planning Analytics Workspace TurboIntegrator process was limited to the number of columns in the data source. The variable for the process were created automatically, one for each column in the source.
Search and filter on hierarchies The Data tree for books and the Databases tree for workbenches now displays a search box under a dimension when the dimension contains 11 or more hierarchies.