- TM1Py and ChatGPT to Analyse Financial Data in a TM1 cube
- White Paper: AI and Data Science in a Functional Database
- Case Study with Procon Analytics: Transitioning from Excel to a customized FP&A solution
- Rocks from the River: an approach to harnessing complexity
- Waterfall Charts in Planning Analytics Workspace
- The Lightbulb Files with Mark Weller
- Discover the New Pulse v6.4
- Unlock the Full Potential of TM1 with Arc & Slice v4.4!
- Cost Allocations in FP&A Models
- What’s New and Depreciations for IBM Planning Analytics Workspace, version 2.0.96
- July Online Classroom Schedule
- Join Us for a FREE Online Course!
- Post Training Insights
- Educational Induction Sessions
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.
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
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”.
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.
- 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 July.
Join Us for a FREE Online Course!
🗓️ 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!