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 February 5th. Our classes are designed for convenience, spanning two half-days, allowing you to seamlessly balance work commitments with online studies.

Class Timing:

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

Developer Fundamentals (PAW)/(Perspectives)
Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes.

Advanced TurboIntegrator (PAW)/(Perspectives)
Learn how experts use TurboIntegrator (TI) to write code beyond the restrictions provided by the wizard.

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

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 benefits:

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

End User MDX (PAW)

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!

End User (Slice)

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!

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 TM1py Post Training Insight, TM1py Connection Checker.

Marius Wirtz, the creator of TM1py, developed this small tool to simplify the testing of various connection parameters and aid in troubleshooting errors encountered when connecting from TM1py to TM1.

The motivation behind its creation is to streamline the process of diagnosing connection issues by providing a readily available tool for testing different parameters. This tool aims to eliminate the need for repeatedly writing similar code while still offering an easy-to-use interface for identifying common exceptional states, such as incorrect credentials, improper port configurations, or TM1 server unavailability.

The TM1py Connection Checker serves as a valuable resource for users seeking to efficiently diagnose and address connectivity issues within their TM1 environment.

Exciting Horizon Update! We are thrilled to share the latest presentation in our monthly series – Planning Analytics Workspace Latest and greatest features by Ramselvan Natarajan.

Key Takeaways:

• 💡Reports and Analysis: Synchronized widgets, target selection, and enhanced visualization.
• 💡Application and Plans: Usability improvements and new task completion options.
• 💡Data Models: Expanded capabilities for robust data modeling.
• 💡Administration: View last login for users and pause auto-refresh in the database threads page.

Watch Ram’s presentation for a comprehensive overview of the latest enhancements in IBM Planning Analytics Workspace.

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 Jon, a seasoned Cubewise TM1 Developer. Having transitioned from a role as a business developer, Jon has encountered numerous enlightening moments while working with TM1. However, it was when he faced the challenge of handling a 2 million dimension model that he truly comprehended the immense power of TM1. Jon enthusiastically conveys his desire for a wider global embrace of TM1, recognising its incredible potential that can revolutionise the way businesses operate.

Cubewise Innovation Week 2024 is just around the corner, starting on Monday, February 12th!

Join us for an exciting lineup of events, including the launch of TM1py 2.0, Atmosphere, and its serverless functions, as well as a massive PowerConnect announcement.

We’ll also be diving deep into v12 with IBM Planning Analytics Engine on AWS and TM1py, discussing the increasing popularity and importance of DevOps, and asking how fast is fast enough when loading and processing Planning Analytics data.

Join the Cubewise team as we get high-tech in 2024 with IBM Planning Analytics:

• Planning Analytics & Power BI Integration + Global PowerConnect Product Update
• TM1py v12 Supportability + Planning Analytics Engine Feedback 
• Atmosphere – Serverless Functions for Planning Analytics
• DevOps Tools & Practices for Planning Analytics
• Faster Data Processing with Planning Analytics – Can it ever be fast enough? 

The recent economic trends have sparked a notable surge in limited partnership investments within private markets, signaling promising prospects for the industry’s long-term growth. This positive momentum in returns has driven increasingly sophisticated investors to allocate a larger portion of their strategic asset allocation (SAA) to private markets across various asset classes.

Whether focusing on private equity (encompassing venture capital, growth, and buy-out deals), private debt, private real estate, or infrastructure investments, there exists a plethora of opportunities for adept institutional investors to venture into the private investing realm. This can be achieved through direct investments in specific assets, participation in investment funds structured as Limited Partnerships, adopting a fund of funds model, or engaging with a traditional hedge fund.

In this article, the Apliqo FP&A team’s emphasis will be on the Limited Partnership approach, elucidating the distinct benefits it offers in contrast to direct investments. Furthermore, they will delve into three specific use cases for portfolio management technology that can enhance outcomes in these types of transactions.

IBM has been regularly introducing new updates on Workspace, which can be challenging to keep track of. But don’t worry, we’ve got you covered. Check out our quick 5-minute summary of all the latest changes for version 2.0.92, released on the 11th of December, 2023.

What’s New:

• Two new properties for single-cell widgets.
• Pass Context option for seamless data transfer.
• Process Editor Improvements.
• Admin Power: Add individual users on Planning Analytics Local and effortlessly switch between multiple PA Local environments on PAW.

Deprecations:

• Classic Dimension Editor: Evolved into the new experience Dimension Editor.
• Future Deprecation Alert (version 2.0.93): Selector list and Selector tile widgets will gracefully transition to the more customizable Selector visualisation.

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

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 modelling – 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 visualisations 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.

IBM® Planning Analytics for Microsoft Excel was refreshed on December 11, 2023 to include the following updates.

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.