Jul 2 2024

Monthly Newsletter, July 2024

Explore a curated collection of enriching topics tailored to inspire and educate. Whether you’re a seasoned professional or a curious learner, discover insights that await you in this edition.

For further exploration or questions, contact us at edu@cubewise.com.

TM1Py and ChatGPT to Analyse Financial Data in a TM1 cube


Explore how TM1py and ChatGPT can be used to analyse Planning Analytics data and demonstrate how AI can enhance your data analysis.

Watch the deep dive of these tools here.

White Paper: AI and Data Science in a Functional Database


Achieve more accurate, consistent, and data driven results quickly and easily by integrating AI into your TM1 model. In this white paper, you will learn:

  • Generative AI provides a unique opportunity for organizations to leverage large and complex data sets, especially when training models with a lot of data to provide feedback.
  • Organizations using Planning Analytics are uniquely positioned to take full advantage of generative AI.
  • The TM1 Database engine’s in-memory technology provides a strong foundation for building predictive solutions due to its embedded business logic and driver-based planning model.
  • Common data science approaches that can be applied to planning analytics include linear regression and time series forecasting, decision optimization, and generative AI, each with its own benefits and applications.
  • Time series forecasting methodology is a tried-and-true approach that uses historic actual data to project future outcomes, and it’s particularly effective for forecasts consistent with a long history of data.
  • Decision optimization involves generating mathematically balanced results based on aligned constraints, allowing for high-performing forecasts and plans that consider limitations and restrictions.
  • Generative AI, powered by deep learning models, is a cutting-edge technology with multiple applications, especially for organizations with confidence in data values.

Read the white paper here.

Case Study with Procon Analytics: Transitioning from Excel to a customized FP&A solution


It’s impressive how Procon Analytics recognized the limitations of using Microsoft Excel for their FP&A needs, and proactively sought a better solution to overcome their challenges. Moving to a more powerful and collaborative FP&A solution was imperative for their continued growth and success. In this case study, learn how:

  • Cubewise’s expertise in assisting clients with transitioning to a more powerful FP&A solution
  • Challenges faced by Procon Analytics due to inefficiencies in using Microsoft Excel for FP&A
  • Key problems included time-consuming manual planning, greater chance of human error, siloed data, lower efficiency and organization, less powerful capabilities, and a short-term mindset
  • Procon Analytics’ objectives to streamline planning function, provide insightful reporting, and create a scalable data environment
  • Key requirements for FP&A function enhancement, including consolidated financial statements, entity-specific planning and reporting, intercompany eliminations, service revenue amortization, inventory tracking and forecasting, integration with internal systems, and enhanced cost optimization

Read the case study on how Procon Analytics shifted from Excel-based planning to IBM Planning Analytics.

Rocks from the River: an approach to harnessing complexity


Struggling with complex projects? Robin Stevens‘ article, “Rocks from the River: An Approach to Harnessing Complexity,” shows you how to tackle intricate systems by starting in the middle.

Key Insights:

  • Begin with one module and build from there.
  • Understand data flow and integration.
  • Create intuitive user interfaces.
  • Transform complexity into clarity.

Read the full article and start building your bridge today!

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 Mark Weller


Meet Mark, Cubewise UK’s General Manager. He went from studying IT, working in financial systems to experience a pivotal moment of realization with TM1.

Introduced to TM1 by a colleague, he encountered its true potential when faced with the task of pre-consolidating data. From that point onward, he embraced TM1 , becoming a proficient user. He confidently asserts: “I’ve never looked back”.

Learn about Mark’s journey.

Discover the New Pulse v6.4


The CODE team is excited to release Pulse v6.4, packed with features to streamline your workflow and boost productivity.

Key Highlights:

  • Support for TM1 v12 on AWS and MCSP: Monitor and manage TM1 instances on IBM Cloud AWS and MCSP.
  • Export Flow Diagram to CSV: Easily export TM1 object relationships to CSV.
  • New Alert Generation Button: Quickly create alerts from templates.
  • Offline Package Execution: Execute offline packages from the Pulse Web Client for seamless migrations.

For more details, read the full update here.

Unlock the Full Potential of TM1 with Arc & Slice v4.4!


The latest update from the CODE team brings enhanced connectivity, powerful features, and significant improvements for your IBM Planning Analytics experience.

Key Highlights:

  • Seamless Connection to IBM Planning Analytics on MCSP (TM1 v12): Easily connect using your API key and IBM-provided URL.
  • Test Hub: Replaces Test Centre and introduces “Test Coverage” for Arc+ to measure TM1 code coverage.
  • Pulse Migration Made Easy: Migrate processes from Pulse to Arc with the new wizard in the Process Editor.
  • Enhanced MDX Editor: Supports drag & drop, formatting, auto-complete, and integration with the Subset Editor.
  • Live Installation of Bedrock Processes: Install and upgrade Bedrock processes directly from Arc.

For more details, read the update here.

Cost Allocations in FP&A Models


A breakdown of essential strategies to enhance profitability analysis across your business. Key points that you will learn with this analysis on starting a project:

  • Traditional linear project approaches can fall short in complex, real-world environments.
  • Designing models is like building bridges, connecting different parts of an organization.
  • Working with existing systems requires understanding and piecing together various components.
  • The “Rocks in the River” approach entails starting with small modules and gradually building understanding.
  • Gaining a fuller picture of the model allows for the establishment of a strong foundation.
  • Tools like Pulse and Apliqo UX in Planning Analytics can greatly assist in navigating complex systems.

Read the full analysis to find out more!

What’s New and Depreciations for IBM Planning Analytics Workspace, version 2.0.96


What’s New in Books and Reporting

  • Use AI to interact with books using natural language
  • Set Consolidations
  • Lock row heading column width
  • Additional options on an Action Button
  • Improved error toast messages and error handling
  • Show and Hide format area

What’s New in Modelling

  • Create users in Planning Analytics Local database
  • Localise objects on your database with localisation editor
  • Use improved auto-complete and validation to simplify Rules creation
  • Schedule chores using Daylight Savings Time (DST)
  • Preview a location data source in the process editor

What’s New in Administration

  • View the version for a snapshot

Deprecations

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

Watch a breakdown of what is in version 2.0.96.

July Online Classroom Schedule


 📅 Mark Your Calendar for July 4th!

Join us for brand-new training sessions designed to enhance your knowledge and skills.

🎓 Unlock Boundless Opportunities! Secure your spot today for an incredible learning experience in July.

Join Us for a FREE Online Course!


👉 Sign Up Today!

🗓️ Date: 04 July
 🕘 Time: 9:00am AEST | 8:00am BST
 ⏰ Duration: 1 Hour

Introducing our latest course: “Understanding the Value of IBM Planning Analytics / TM1“!

🔍 What You’ll Learn: Discover TM1’s value and benefits, explore its functionalities, and understand its flexibility in enhancing organizational analytics capabilities.

  • Why Spreadsheets Fall Short in Modern Data Analysis
  • Core Concepts of IBM Planning Analytics
  • Exploring IBM PA’s Vast Capabilities
  • The Concept of Models in IBM Planning Analytics
  • Familiarizing with IBM PA Interfaces

💡 Whether you’re new or experienced in analytics, this course offers insights to elevate your skills.

Ready to transform? Enroll now and unleash IBM Planning Analytics’ full potential!

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:

  • How TM1 Really Works: Understand data storage, Feeders, dimension order impact, and suppression of empty values.
  • Advanced Rules Calculations: Step-by-step demo on advanced techniques for business requirements.
  • Solution for Consolidated Forward Weeks of Cover: Learn to calculate Forward Weeks of Cover at different consolidated levels.

Explore these insights now!

Advanced Rules (PAW) Insights
Advanced Rules (Perspectives) Insights

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:

  • July 03: 8:00am AEST (RSVP) / 8:00am BST (RSVP)
  • July 17: 8:00am AEST (RSVP)  / 8:00am BST (RSVP)
  • July 31: 8:00am AEST (RSVP)  / 8:00am BST (RSVP)

Looking forward to seeing you at the next Induction session!

Related content

Loading related content