Welcome to the August 2024 Cubewise Educational Newsletter! Whether you’re looking to enhance your skills or explore new tools, we’ve got something for everyone.

August Online Classroom Schedule
Embark on an exciting journey of knowledge and skill enhancement with our training content.
Dive into expertly designed half-day sessions, allowing you to balance work commitments seamlessly with engaging online studies.
- 📅 Expertly Designed Half-Day Sessions: Online Training Schedule
- 🔗 Register Now: Join the Training
- 🔍 Discover Our Courses: Explore Course Details
- 💡 Diverse Educational Offerings: Educational Options
- ❓ Need More Info? Contact us at edu@cubewise.com.
🎓 Unlock Boundless Opportunities! Secure your spot today for an incredible learning experience in August.

Unlock the Full Potential of Pulse
Pulse is essential for optimising your TM1 Server with IBM Planning Analytics. Our Pulse Fundamentals course offers the skills to ensure your server performs at its best.
🔗 Enrol Today: Join the Training
Course Breakdown:
- Navigating Pulse’s Interface
- Essential Business Cases
- Auditing Applications
- Managing the Development Process
- Reporting the Server’s Status
- Documenting the TM1 Server
- Administering the TM1 Server
What Attendees Are Saying:
“A fantastic trainer ! Liesl seems very excited to teach classes. She has the knowledge, and especially to a level that she can just say what was added/removed in the earlier or newer versions of Planning Analytics. This is awesome!! I have a gained a greater understanding of Planning Analytics after taking many of the advanced courses under her mentorship. Thanks Liesl.”
— Parvez Mohammed
Training Details:
Upcoming Online Classroom Sessions:
- 18 + 19 Sep: 8am to 12:00pm BST
- 19 + 20 Sep: 9am to 1:00pm AEST
Prefer a different schedule? Start self-paced training on your own timeline!

TM1World Teams Championship 2024!
Event Details:
Date: October 2024
Format: One-day team-building experience
Eligibility: Teams of 3 from the same company
How to Register:
- Form a team of three colleagues from your company.
- Send an email to TM1WorldChampionship@cubewise.com to express your interest.
Elevate your team-building experience and showcase your TM1 Planning Analytics expertise on a global stage. If you and your colleagues are passionate about TM1 and eager to demonstrate your skills, gather a team of three from your company to participate in this exciting challenge.
This is your chance to shine, connect with like-minded professionals, and gain recognition within the TM1 community. Prepare for a day of intense problem-solving, strategic thinking, and collaboration.
Don’t miss out on this incredible opportunity. Mark your calendars and start assembling your dream team today to be part of the TM1 World Teams Championship 2024!

Post Training Insights
Stay ahead with our evolving repository of tips and techniques, shared at the end of each training resource. Gain deeper insights and continuously enhance your skills with these new additions to the End User (Planning Analytics Workspace) training resource:
- AI Forecasting in IBM Planning Analytics Workspace: Learn how to generate a forecast based on historical actuals.
- Make your analysis easier with IBM Planning Analytics Workspace: Maximise Planning Analytics Workspace by learning how to:
- Reconcile Data Easily
- Secure deployed modules
- Synchronise between workbooks in Planning Analytics
- PAW’s synchronisation capabilities
- How to manage and aggregate different plans using IBM Planning Analytics Workspace: Gain insights into the following topics:
- Introduction to Marketing Planning and Planning Analytics Workspace
- Planning, Reports & Admin Console Overview
- Using Business Admins to Manage Assets in Planning Clinics Workspace
- IBM Planning Analytics Workspace – The Latest and Greatest Features: Unlock the power of IBM Planning Analytics Workspace with the latest features and enhancements for seamless data analysis and management
Explore these insights now!
Available to Course and Power User Members.

Educational Induction Sessions
Join our fortnightly Educational Induction sessions to maximise your membership benefits and kickstart your learning journey.
What to Expect:
- Discover membership benefits.
- Explore the Community Hub and Video Hub.
- Receive step-by-step guidance.
- Stay updated on events.
- Participate in Q&A sessions.
Mark your calendar and RSVP for a session that fits your schedule:
- Aug 14: 8:00am – 9:00am (AEST – RSVP) (BST – RSVP)
- Aug 28: 8:00am – 9:00am (AEST – RSVP) (BST – RSVP)
Looking forward to seeing you at the next Induction session!

Presentation of the month
We’re thrilled to present the latest installment in our monthly series – Using Apliqo UX beyond TM1 and Spreadsheets, welcome SQL, presented by Tomer Ganz.
Key Updates:
💡ODBC Integration: Easily connect, manage, and visualise data.
💡Annual Report Export: Export to Excel, manipulate with TM1 add-on.
💡Documentation: Moved to Confluence; enhanced training resources.
💡TM1 Enhancements: Better data analysis, improved tools.
💡New Features: Merge widgets, virtual dimensions, and more.
Catch the full recording to dive deeper into these exciting updates!

Waterfall Charts in Planning Analytics Workspace
Learn how to create waterfall charts in Planning Analytics Workspace, covering both Classic and Bridge types leveraging TM1py and MDX, plus how to visualize changes across dimensions and create dynamic, insightful charts.
Watch for practical tips, useful links and a comprehensive walkthrough.

The Lightbulb Files with Mathilde Opsomer
In an effort to showcase our profound passion for IBM Planning Analytics/TM1, we asked Cubewisers about their ‘lightbulb moment’ experiences.
Meet Mathilde, TM1 Consultant at Cubewise. Working in the division focused on supply chain management, she discovered TM1 within her former company. Exhausted by “Excel hell”, TM1 was a saving solution for her. According to her, TM1 offers easy access to data and multidimensionality.
Learn about Mathilde’s journey.

Syncing Hierarchies: TM1 and Power BI
Unlock the full potential of your data with TM1 and Power BI.
- Discover how hierarchies and consolidations in IBM Planning Analytics (TM1) can organise and analyse complex data sets.
- Learn how structured data at various levels of granularity provides insights from sales regions down to individual cities, and from overall financials to specific departments.
Dive into our article from the CODE team to see how these powerful features can transform your data analysis capabilities.
Read the blog to find out more!

Simplifying TM1 Reporting with Slice
In a fast-paced business world, efficient and accurate reporting is essential. Slice simplifies your TM1 reporting by integrating seamlessly with Excel, allowing for dynamic, real-time reports and quick, in-depth analyses.
Key Features:
- Cell Audit: Easily identify and fix errors.
- Virtual Consolidation: Create ad-hoc consolidations without altering data.
- Trace Rules: Understand complex calculations with ease.
- Remove TM1 Functions: Share clear, static reports effortlessly.
Discover how Slice can transform your reporting. Read more on our blog!

5 Reasons to Switch from Perspectives to Slice
Considering a switch from IBM Perspectives to Slice? Discover why transitioning could be a game-changer for your TM1 environment.
- End of Life for Perspectives: IBM Perspectives will no longer receive updates or support. Moving to Slice ensures your software remains secure and up-to-date with the latest enhancements.
- Easy Installation: Slice simplifies deployment with a user-friendly installation process, eliminating the need for IBM Planning Analytics Workspace. Get up and running quickly with minimal disruption.
- Familiar Interface: Slice maintains a similar look and feel to Perspectives, making for a smooth transition and reducing the need for extensive training.
- Developer Features: Enjoy the benefits of integrated developer features, combining the best of TM1 Architect within a single interface for efficient model management and development.
- Enhanced Functionality: Slice supports all existing Perspectives features and adds new capabilities, including dynamic columns, MDX forms, and improved performance.
Embrace the future of TM1 with Slice—start your transition today and experience the enhanced functionality and support.
Discover how Slice can transform your TM1 environment. Read more on our blog!

What’s New and Depreciations for IBM Planning Analytics Workspace, version 2.0.97
General Update
- Central settings editor
What’s New in Books and Reporting
- Automatic Action Button Book Reference
- Plot members from the same dimension
- Refresh and Commit button
- Spacer formatting
What’s New in Plans and Applications
- Colour-coded tags
What’s New in Modelling
- Sort hierarchy members
What’s New in Administration
- Object deletion
Deprecations
- End of support for Linux Red Hat Enterprise 7 (local only)
Watch a breakdown of what is in version 2.0.97.

What’s New and Fixes for IBM Planning Analytics for Excel, version 2.0.97.1
What’s New
- Run watsonx AI jobs
Fixes
- Create a Universal Report when connected to multiple sources