Upskill your know-how on IBM Planning Analytics/TM1, through our consultant-led training.

Prepare to embark on a comprehensive journey of knowledge and skill development commencing on January 9th. Enrol with us for an enriching experience that seamlessly integrates learning and professional growth.

Class Timing:

• Australian Time Zone: 9:00 am to 1:00 pm AEDT (conducted over two half-days)
• Asian Time Zone: 9:30 am to 5:30 pm HKT
• European Time Zone: 8:00 am to 12:00 pm GMT (conducted over two half-days)

Developer Fundamentals (PAW)
Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes.
✅ Language: English, Cantonese/ Mandarin

End User (PA for Excel)
Learn to explore data to be a proficient analyser and get to know all the reporting possibilities in Excel.
✅ Language: English, Cantonese/ Mandarin

Advanced Reporting (PA for Excel)
Learn the intricacies required to create dynamic reports in Excel.
✅ Language: English

Advanced TurboIntegrator (PAW)
Learn how experts use TurboIntegrator (TI) to write code beyond the restrictions provided by the wizard.
✅ Language: English, Cantonese/ Mandarin

Advanced Rules (PAW)
Learn how to write multi-cube logic and clearly understand how feeders work to ensure an efficient model.
✅ Language: English

Check our website for more details on each course.

Power Up Your Learning with the Power User Membership:
Take your professional growth to the next level with our exclusive Power User Membership, offering these benefit:

• Community Hub Access: Connect with like-minded professionals, fostering networking and collaboration for a richer learning experience.
• Access to Extensive Educational Content: Dive into a vast library of over 400 presentations from past conferences and webinars.
• Attend All Courses: Unlock the door to comprehensive learning by participating in all available courses.
• Flexible Learning Options: Tailor your learning experience to your preferences and schedule. Choose between attending live online classrooms with instructors or opt for self-paced courses.

Email edu@cubewise.com for more information.

We are excited to introduce the highly anticipated End User MDX (PAW) course…. available now!

Dive into the dynamic world of IBM Planning Analytics and revolutionize your data analysis with the power of Multidimensional Expressions (MDX). Elevate your skills to new heights and gain a competitive edge by mastering the art of reading and writing MDX for end users.

With this course, you will learn:

• How to read the MDX syntax 
• How to filter the dimension to return a list of members
• How to get a member’s attribute
• How to sort members
• How to combine sets
• How to get a cube’s view
• How to apply an MDX to PA for Excel

Whether you prefer self-paced learning or the vibrant environment of an online classroom, this course caters to your style of learning.

Register today now and be part of the MDX revolution!

Discover the power of Slice, an Excel add-in designed to seamlessly display and update values from a TM1 database through cell-based functions. This course equips you with the essential skills to harness the capabilities of Slice.

Learn:

• How to use the Explorer
• How to use the Cube Viewer
• How to use the Subset Editor
• How to use export reports to Excel

This 4-hour course is tailored for self-paced learning, complemented by one hour of personalised mentoring.

Ready to dive into the world of Slice? Register now!

We are thrilled to announce the launch of three new courses that will leverage PAW for Developer Fundamentals, Advanced Rules, and Advanced TurboIntegrator. These courses are clearly identified in the Training Courses list with the inclusion of the term ‘PAW.’

For those who prefer the Perspectives platform, our existing courses will continue to be accessible for Self-Paced training.

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!

We are excited to release the Advanced TurboIntegrator Post Training Insight, Uploading a file with an Action Button.

This functionality empowers users to seamlessly upload properly formatted files into Planning Analytics in PAW.

Exciting Horizon Update! We are thrilled to share the latest presentation in our monthly series – Lessons learned while migrating from Perspectives by Jakub Górski.

Migrating from Perspectives to Planning Analytics for Excel is not just a necessity but a strategic move. It overcomes Perspectives’ limitations, introduces new features, and significantly enhances performance, positioning TM1 users for improved efficiency and effectiveness in reporting processes.

Watch Jakub’s presentation from Horizon 2023 to navigate the migration successfully and unlock the full benefits of Planning Analytics.

Stay tuned for more enlightening presentations each month in the Horizon series.

Reach out to us at edu@cubewise.com if you have any questions or feedback.

Meet Chris, Cubewise UK’s Business Development Manager. Starting off as an assistant accountant, it was during the implementation of the new employer’s forecast model that he became a skilled TM1 user. He confidently asserts, “TM1 will have a long future”.

Transitioning from TM1 Perspectives to an alternative solution is an important change that is becoming more and more eminent. Moving away from Perspectives is necessary to leverage the latest features of IBM Planning Analytics such as Hierarchies.

For some companies, this is a significant change due to the familiarity and ease of use that their end users have with the good old TM1 Perspectives.

Cubewise Slice is a great alternative to TM1 Perspectives, offering enhanced functionality and performance with a very similar user experience.

All Excel reports built with Perspectives will work in Slice. The only work that needs to be done is to convert the buttons, and Slice includes a feature to do it for you.

Here the Code team gives you a 6-step list for you to consider should you decide to make the move. The Code team also provide you with digital documentation to assist you in a transition from TM1 Perspectives to Slice.

• Step 1: Assessment and Planning
• Step 2: Downloading Slice
• Step 3: Installation and Configuration
• Step 4: Validation
• Step 5: Training and Documentation
• Step 6: Support and Maintenance

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.92

Changes to single cell widget properties
The Show as cell property for single cell widgets has been updated to control only the display of an outline around values in single cell widgets. A new property, Enable editable cell, now allows modification of values in single cell widgets. Previously, you could modify values in single cell widgets with the Show as cell property but couldn’t remove the outline around values in the widgets.

What’s new in plans and applications – 2.0.92

Pass context between books in an application or plan
You can now pass context between books that are added as assets in an application or a plan that use the same synchronisation group.

What’s new in modeling – 2.0.92

Process editor improvements
The Script tab on the process editor in Planning Analytics Workspace 2.0.92 introduces several performance and usability improvements that make it easier to create and manage your process scripts.

What’s new in administration – 2.0.92

Add an individual user in Planning Analytics Administration Local (Local only)
A new UI option lets you add an individual user in Planning Analytics Administration Local.

Create and edit multiple Planning Analytics Local environments (Local only)
You can manage multiple environments in Planning Analytics Administration Local.

Important note on upgrading to Planning Analytics Workspace Local 2.0.92 – Administrator roles
Planning Analytics Workspace Local now supports multiple environments.

What’s new in administration – 2.0.92

Classic dimension editor removed from Planning Analytics Workspace 2.0.92
 As of release 2.0.92, the classic dimension editor is no longer available in Planning Analytics Workspace.

Selector lists and Selector tile widgets to be replaced by Selector visualizations in Planning Analytics Workspace 2.0.93
Any Selector list or Selector tile widget present in books will be converted to a Selector visualisation in Planning Analytics Workspace 2.0.93.

Planning Analytics for Microsoft Excel

Read about what’s new or updated in IBM® Planning Analytics for Microsoft Excel.

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.

Updated Spread Data interface for Universal Reports
Learn about the new Spread data options and new spreading methods that are available only for Universal Reports in Planning Analytics for Microsoft Excel.

Drill through for Universal Reports
Drill Through is now available for Universal Reports in IBM Planning Analytics for Microsoft Excel.

New TM1Val hierarchy spreadsheet formula
TM1Val is a new hierarchy-aware spreadsheet formula available in IBM Planning Analytics for Microsoft Excel.

Known issues in Planning Analytics for Microsoft Excel 2.0.92
The following are known issues in Planning Analytics for Microsoft Excel. These issues will be resolved in a future release.

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 December 11, 2023 to include the following changes.

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.

Pick lists supported in Universal Reports for TM1 Web
The pick list feature familiar to users is now available for Universal Reports in IBM Planning Analytics TM1 Web.

New TM1Val hierarchy spreadsheet formula
TM1Val is a new hierarchy-aware spreadsheet formula available in IBM Planning Analytics TM1 Web.