May 7 2024

Monthly Newsletter, May 2024

Welcome to education and inspiration with the May edition of Cubewise’s Educational Departments Newsletter.

This month, we have curated a diverse array of topics designed to captivate and enlighten you. Whether you’re a seasoned professional or a curious learner, there’s something special waiting for you within this newsletter.

We invite you to delve into this enriching read and uncover the insights that await.

Should you wish to explore any topic further or have any questions, don’t hesitate to reach out to us at edu@cubewise.com.

May Online Classroom Schedule


 📅 Prepare for an exhilarating journey of knowledge and skill enhancement starting May 7th!

Join us for classes designed with your convenience in mind, spread over two dynamic half-days. Strike the perfect balance between your work commitments and engaging online studies effortlessly.

Secure your spot today and unlock a realm of boundless opportunities!

For an in-depth look at each course, dive into our website: Link

Whether you’re new to IBM Planning Analytics or aiming to take your skills to the next level, we offer a diverse range of options to empower yourself, your team, or your entire organisation. Explore our educational offerings here: Link

Questions or need more details? Don’t hesitate to reach out to us at edu@cubewise.com. We’re here to ensure you extract maximum value from your learning journey!

Dive into our New Course!


Introducing our latest addition to the learning catalogue: “Introduction to IBM Planning Analytics”!

This course is designed to equip you with the foundational knowledge needed to harness the power of IBM PA, empowering you to optimise organisational functions like never before.

Here’s what you’ll explore:

  • Understanding Why Spreadsheets Fall Short in Modern Data Analysis
  • Delve into the core concepts and functionalities driving IBM PA’s cutting-edge technology.
  • Discover the vast possibilities of what you can achieve with IBM PA.
  • Dive deep into the concept of a model in IBM PA.
  • Familiarise yourself with the various interfaces for IBM PA.

💡 Whether you’re a seasoned data professional or just dipping your toes into the analytics realm, this course offers invaluable insights that will elevate your understanding and skill set.

Ready to embark on this transformative journey? Enroll now and unleash the full potential of IBM Planning Analytics! 

Post Training Insight: TM1py Fundamentals


How amazing would it be if we provided a solution, before the need arises? 

That’s what the Post Training Insights is all about! We are always learning new and different ways to use the tool and will share these tips in the Post Training Insights section at the end of the training resource. This will be a repository that will continue to grow so you can gain more knowledge within this course.

A new training insight has been added to the TM1py Fundamentals training resource!   

In most TM1py scripts it is necessary to query cube data from TM1. Usually, TM1py scripts are also parametrized. For instance, a timeseries forecasting script must work for any given region and product element.

So TM1py scripts must be capable of querying TM1 data dynamically based on passed parameters.

The best way to accomplish this is to use MDX with MDXpy. 

Check it out now!

Dynamic TM1 queries with MDXpy

This repository is available to Course or Power User members.

Induction Sessions


The Educational 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.

Upcoming Dates:  

  • May 08:   8:00am – 9:00am AEST (RSVP)
  • May 08:  8:00am – 9:00am BST (RSVP)
  • May 22:  8:00am – 9:00am AEST (RSVP)
  • May 22:  8:00am – 9:00am BST (RSVP)

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!

TM1 and Planning Analytics User Conferences


🚀 Gear up for an unparalleled experience at the Cubewise TM1 and Planning Analytics User Conference!

💡Dive into insights from industry leaders, explore trends, and ignite your business strategies!

👉 Why Attend?

  • Engage: Connect with industry experts through insightful roundtable discussions.
  • Inspire: Gain valuable insights from deep-dive sessions igniting your creativity. 
  • Explore: Experience cutting-edge technologies through Interactive Tech Showcases.
  • Network: Expand your professional network during the evening networking session.

🔥Limited spots available – Secure your free registration now!

📅 Event Dates:

We look forward to welcoming you at the TM1 and Planning Analytics User Conference.

Presentation of the Month from Horizon 2023


Exciting Horizon Update! 🌐 We’re thrilled to share the latest presentation in our monthly series –  Arc+: The most advanced developer experience for IBM Planning Analytics, presented by Harvey Withington.
 
Are you seeking to streamline your Planning Analytics implementation lifecycle? Look no further! Introducing ARC Plus – the ultimate solution tailored to enhance efficiency, reduce maintenance, and foster best practices in your journey with Planning Analytics.
 
In this session, you’ll discover:
 
🔍 Explore Comprehensive Capabilities: ARC Plus seamlessly integrates Pulse features into ARC, empowering you with a holistic approach to support and administration.
 
🎯 Optimize Efficiency: From best practice validation to advanced monitoring, ARC Plus ensures optimal performance at every stage of your application lifecycle.
 
📈 Maximise Productivity: Say goodbye to tedious tasks with ARC Plus’s robust features, including full model search, object usage tracking, and chores process history.
 
🔧 Facilitate Collaboration: With documentation access and Pulse integration, ARC Plus becomes your go-to platform for seamless collaboration and knowledge sharing among Team One professionals.
 
Watch this presentation, Elevate Your Planning Analytics Experience with ARC Plus! 

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

The Lightbulb Files: Tom Beare


In an effort to showcase our profound passion for IBM Planning Analytics/TM1, our Control CC team asked Cubewisers about their ‘lightbulb moment’ experiences.

Meet Tom, Cubewise Systems Consultant. He started using TM1 when he was at the finance department for weekly reporting. However, it was when he faced the need for additional reporting capabilities that he unearthed the true power of TM1 — “You can create whatever you want”.

Introducing PowerConnect


Cubewise PowerConnect offers a tailored solution for enhancing your Power BI reporting capabilities by connecting seamlessly to IBM Planning Analytics (TM1) data sources that may not be directly supported by default connectors.

Connecting to your TM1 Databases

Many organizations encounter challenges when their TM1 data doesn’t align perfectly with Power BI’s native connectors. This can be frustrating for power users and end users alike, especially when existing reports don’t meet specific needs or when Power BI is the designated dashboarding tool within the organization.

What’s the Solution?

Enter PowerConnect, a custom connector designed to bridge the gap between TM1 and Power BI. PowerConnect not only reads TM1 data and metadata but also inherits TM1’s data security model. This ensure a smooth integration of TM1 data into Power BI for in-depth analysis and visualization.

For example, imagine a company with a typical General Ledger data model in TM1. Now, let’s say you want to analyze expense data alongside other data sources in Power BI. With PowerConnect seamlessly connecting to your TM1 database, importing and refreshing TM1 data in Power BI becomes a few simple clicks away.

Read this article to find out more…

A Developer’s Perspective – Navigating the Transition to TM1 v12


In the ever-evolving landscape of IBM Planning Analytics with Watson (“Planning Analytics”) development, the release of IBM Planning Analytics Engine (“TM1 v12”) brings challenges and exciting opportunities for developers.

In this blog post, Shane Bethea delves into the perspective of a Planning Analytics developer, focusing on critical areas such as deprecated functionality, the migration process from v11 to v12, and noteworthy changes and additions.

It is important to note that from an end-user standpoint, very little has changed in TM1 v12, where you have already migrated to IBM Planning Analytics Workspace (“PAW”) and IBM Planning Analytics for Excel (“PAfE”).

Read this blog to find out more ….

IBM’s April Update, Version 2.0.95


IBM Planning Analytics for Excel

Released: April 18 2024

Learn the latest update for IBM Planning Analytics for Excel version 2.0.95, released on April 18th, 2024.

This version contains one update. The TM1SET refreshes Dynamic Reports when referenced with the TM1RPTROW formula.

IBM Planning Analytics Workspace

Released: April 23 2024

What’s New

  • Books and Reporting
    • Synchronisation settings for hierarchies
  • Plans and Applications
    • Tags in Tasks
  • Modelling
    • File Manager Improvements
    • Rollback Transactions
    • Managing Database Thread Activities

Deprecations

  • End of support for Linux Red Hat Enterprise 7 (local only) – end of Jun 2024
  • End of support for Windows Server 2016 (local only) – end of 2024

Related content

Loading related content