Sep 30 2023
Cubewise EDU’s October 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!
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-28-1.png)
Upskill your know-how on IBM Planning Analytics/TM1, through our consultant-led training.
Classes will commence on October 19 in the Australian and European time zone, and will be conducted over two half-days, helping students balance work and online class.
Class Timing —
– Australian Time Zone: 9:00 am to 1:00 pm AEST
– European Time Zone: 8:00 am to 12:00 pm BST
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/Training-1.png)
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 start developing your own Python and TM1py scripts.
Pulse Fundamentals
Learn the functionalities that come 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.
Check our website for more details on each course.
Interested in upscaling with multiple courses? Join the Power User Membership and enjoy the following benefits:
– An online ticket to Horizon, the global user conference on IBM Planning Analytics / TM1
– Exclusive access to the Power User Community, a dedicated space to share insights and interact with your peers who are also passionate about IBM Planning Analytics / TM1.
– Access to 300+ EDU Video Library from Horizon and webinars
– Flexibility to attend online classrooms or self-paced learning for all our courses
– Extra insights on the course topics.
Email edu@cubewise.com for more information.
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-5-700x117.png)
EDU Induction sessions, are designed to help you maximise the benefits of our educational content. These sessions will equip you with the knowledge and tools necessary to make the most out of your membership.
Session Schedule:
Induction sessions are conducted fortnightly to accommodate various schedules. We highly recommend that all students attend at least one induction session to get started on the right foot.
What to Expect:
– Discover the numerous benefits included in your membership.
– Explore the Community Hub and learn how to connect with fellow learners.
– Navigate through our Video Hub, where you can access a wealth of informative content.
– Get step-by-step guidance on how to start your learning journey.
– Stay updated on upcoming events to enhance your educational experience.
– Participate in a Q&A session to clarify any doubts you may have.
Please mark your calendars for the upcoming sessions and feel free to attend the one that suits you best.
Looking forward to seeing you at the next Induction session!
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/Copy-of-EDU-Newsletter-2560-x-1440-px-1200-x-627-px-1200-×-300-px-21-1.png)
We are excited to release the Advanced TurboIntegrator Post Training Insight, Sleep, undocumented function.
The Sleep function is a simple functions that takes one argument, the number of milliseconds to pause a process execution.
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-16-2.png)
Explore the exciting agenda for Horizon, your gateway to the world of Planning Analytics/TM1. We’ve curated a series of sessions that promise to unlock new perspectives and insights:
💡 Discover innovative techniques in data integration and consolidation.
💡 Unleash the power of Planning Analytics for Excel (PAfE).
💡 Navigate the path to sustainability and cost balance.
💡 Upgrade your Excel experience with the latest technology.
💡 And much more!
Horizon begins on:
🕒 Monday 16th October at 11:00 pm in London and 6:00 pm in New York
🕒 Tuesday 17th October at 9:00 am in Sydney, 6:00 am in Beijing, 3:30 am in Hyderabad, and 12:00 am in Paris
Don’t miss this incredible opportunity to expand your Planning Analytics/TM1 knowledge.
Follow us on LinkedIn to get the latest news on the conference.
Please contact us at horizon@cubewise.com if you have any questions.
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-1-3.png)
The TM1 World Championship is making a triumphant return, and this time, it’s bigger and more competitive than ever!
First up, mark your calendars for October 17 because we’re introducing the first-ever TM1 World Team Championship as part of the global 24-hour Horizon Conference! Three end-user customer teams will go head-to-head, each vying for the prestigious title of TM1 World Team Champions. You will be able to watch it all – and add your vote to help determine the winner! Register for Horizon here to be a part of this thrilling event: Horizon Registration Link
And that’s just the beginning! On October 24, we’re hosting the third-ever TM1 World Individual Championship live and in person in the beautiful Ehningen, Germany, as part of IBM’s TM1 User Day, also known as TM1 Anwendertag. If you’re registered for the User Day, you automatically qualify to compete for the prestigious TM1 World Champion trophy!
Stay tuned for more details on both of these exciting championships in the coming days and weeks.
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-10-1.png)
Watch Ali Candan‘s insightful presentation from Horizon 2022, Marketing Planning, how to manage and aggregate dıfferent plans using PAW to gain insights into the following topics:
– Introduction to Marketing Planning and Planning Analytics Workspace: Explore the fundamentals of marketing planning and its integration with the Planning Analytics Workspace.
– Planning, Reports & Admin Console Overview: Get an in-depth look at the planning process, report generation, and the administrative console’s functionality.
– Using Business Admins to Manage Assets in Planning Clinics Workspace: Discover effective strategies for leveraging business administrators to efficiently manage assets within the Planning Clinics Workspace.
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/Copy-of-EDU-Newsletter-2560-x-1440-px-1200-x-627-px-1200-×-300-px-47-1.png)
Meet Mathias, Senior Cubewise Consultant. Hailing from Denmark, his expertise lies in the fields of accounting and finance. Throughout his professional journey, he experienced a series of lightbulb moments with TM1, the software that revolutionised his work. Mathias emphatically highlights the challenges of dealing with the infamous “Excel Hell” .
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-12-1.png)
15 Minutes with Maurycy Mioduski
Episode 1: In this episode of “15 Minutes with…,” Jon Lee had the opportunity to chat with Maurycy Mioduski, a fellow colleague at the London Planning Analytics User Conference 2023. Jon delved into Maurycy’s TM1 origin story, and what unfolded was a surprising amount of similarity between their backgrounds in the world of IT. There are plenty of intriguing nuggets for those already immersed in the TM1 revolution and for those just embarking on the journey. We’re sure there’s something here for everyone. Sit back, relax, and enjoy the video.
Episode 2: Welcome back for another captivating episode of “15 Minutes with…!” In this second installment, Jon Lee continues his conversation with Maurycy Mioduski. It’s the perfect follow-up to their previous discussion, so if you enjoyed the first part, you won’t want to miss this one!
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/TM1-Breakfast-Show-2-3.png)
Check out all the new features and enhancements here.
Big thanks to all #RushTI and #TM1py contributors who keep improving the free and open-source projects with each release.
![](https://cubewisebackend.kinsta.cloud/wp-content/uploads/2023/11/Copy-of-EDU-Newsletter-2560-x-1440-px-1200-x-627-px-1200-×-300-px-20-1.png)
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.
You can also review all new features introduced since 2.0.58, in the the IBM Planning Analytics Workspace new feature summary table. You can use the table to search for new features across all releases by description. You can also sort new features by release, date, functional area, and description.
What’s new in books and reporting – 2.0.90
Set synchronization properties for multiple widgets simultaneously
You can now set synchronization properties for multiple widgets at the same time. Previously you could set synchronization properties for only one widget at a time.
Ability to delete data from single cell widgets removed
You can no longer use the Delete key to delete data from single cell widgets. The Delete key function was disabled on the contents of a single cell widget to prevent accidental deletion of data. However, you can modify data in a single cell widget, including clearing the value to display 0, or delete the single cell widget altogether.
Select a member or set by typing its name in an exploration view
The exploration view now offers a quick way to select a member or set. You can open an input box from a dimension tile in the Context or Bench area to enter a member name or Member ID and update the view with that member. Similarly, you can open the input box from a tile in the Row or Column area and type the set name to update the view with that set.
Insert spacer rows and columns in explorations
You can now insert spacer rows and columns in explorations through the right-click menu. This is a useful for building stylized views of data in books.
Replace button now works on selections in the Current set
The Replace button in the set editor now also works on the selections you make in the Current set pane. You can select members on both sides of the set editor, either the Available members or the Current set, and replace members in the view.
Virtual set and reset features are now available for the current set in the set editor
All virtual sets (All roots, All members, and All leaves) in the Available members pane in the set editor are now also available in the Current set pane. Additionally, reset features are now available in the Current set pane.
AI-generated recommendations available in the Learn Pane
The Learn Pane now provides dynamic AI-generated recommendations as well as static recommendations.
What’s new in plans and applications – 2.0.90
Usability improvements to the contribution page in Applications and Plans
The contribution page in Applications and Plans include several usability enhancements that make it easier to navigate between applications and plans or to work with assets.
What’s new in modeling – 2.0.90
Work with database logs on the modeling workbench
You can now access the server log, transaction log, and audit log for a database directly from the modeling workbench in Planning Analytics Workspace.
Use baseline forecasting to create and share forecasts
A baseline forecast is a new Planning Analytics Workspace asset that administrators and modelers can create and share with other users in your organization. Administrators, modelers, and analysts with the appropriate permissions can run the baseline forecast at any time and use the forecast to improve the planning process. Consumers cannot run baseline forecasts.
What’s new in administration – 2.0.90
Simplified process to rename databases, snapshots, and user groups
A new Edit option on the Databases, Lifecycle Management, and Users and groups pages simplifies the renaming process.
View a user’s last login in Planning Analytics Administration
An enhancement in Planning Analytics Workspace 2.0.87 added the ability to view the last login for a user when you downloaded a user report from the Users and groups page. You can now view the last login for a user directly in Planning Analytics Administration without downloading a report.
What’s new in Deprecation notices – 2.0.90
Classic cube viewer to be removed from Planning Analytics Workspace 2.0.90
As of Planning Analytics Workspace 2.0.90, the classic cube viewer will be removed from Planning Analytics Workspace.
Planning Analytics for Microsoft Excel
Read about what’s new or updated in IBM® Planning Analytics for Microsoft Excel.
Hierarchy aware Universal Reports are now available in IBM Planning Analytics for Microsoft Excel
Universal Reports, a new hierarchy aware and parameterized report type, is now available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics TM1® Web, and IBM Planning Analytics Workspace websheets. Universal Reports were previously referred to as Dynamic Quick Reports on Planning Analytics for Microsoft Excel’s roadmap.
Planning Analytics for Microsoft Excel now defaults to WebView2
IBM Planning Analytics for Microsoft Excel’s authentication flow and shared components now use Microsoft Edge WebView2 by default. WebView2 allows Planning Analytics for Excel to be compatible with newer web standards and technologies. Planning Analytics for Excel has supported WebView2 since version 2.0.74 through feature flags.
What’s new in TM1 Web
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.
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.90.
Universal Reports available in TM1 Web and Planning Analytics Workspace websheets
Universal Reports, a new hierarchy aware and parameterized report type, is now available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics TM1 Web, and Planning Analytics Workspace websheets.