Cubewise EDU’s July Newsletter

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

Classes commence on July 10, in the Australian and European time zone,  and will be conducted over two half days, helping students balance work and online class.

– Australian Time Zone: 9:00 am to 1:00 pm AEST
– European Time Zone: 8:00 am to 12:00 pm BST

Advanced MDX
Learn how to write advanced MDX within TM1 and client applications such as PAW and Planning Analytics for Excel to control the data received.

TM1py Fundamentals
The ideal foundation to start developing your own Python and TM1py scripts.

Pulse Fundamentals
Learn the functionalities that come with Pulse such as live monitoring, user analytics, Excel analysis, documentation, migration and proactive alerts.

Apliqo UX Fundamentals
Learn how to create a modern, curated web experience for your IBM Planning Analytics/TM1 users.

Check our website for more details on each course.

Looking to upskill in more than one course? Join the Power User Membership and gain access to ALL our courses!

Email edu@cubewise.com for more information.

EDU Induction sessions, enable members to make the best use of the educational content we have to offer.

We will go through:

– Benefits included in your membership
– Walkthrough of the Community Hub
– Walkthrough of the Video Hub
– Steps to follow when you are ready to commence training
– Upcoming events
– Q&A

Sessions are conducted fortnightly.

We recommend all students attend an induction. Please RSVP to a session that fits your schedule.

Email edu@cubewise.com for more information.

We are excited to release the Advanced TurboIntegrator Post Training Insight, SubsetCreateByMDX, undocumented parameter

The IBM server team continues to improve IBM Planning Analytics/TM1 to meet various customer requirements, and sometimes features are developed that aren’t documented. This is one of them!

Reach out to edu@cubewise.com if you have any questions.

Horizon, the biggest knowledge-sharing event dedicated to IBM Planning Analytics/TM1, is back for the fourth year, on Tuesday 17th October, beginning at 9 am, Sydney Time, and following the sun across the globe over 24 hours!!

More on the agenda will be revealed in the coming months, however, we guarantee that you will learn:
– insights from IBM
– new models companies have implemented from across different industries
– interesting discoveries that experts have come across

Don’t miss your opportunity to influence the agenda! Submit your topic suggestions today.
Registration opens soon! Follow us on LinkedIn to get the latest news on the conference.

Please contact us at horizon@cubewise.com if you have any questions.

Using TM1py and the latest functionality in IBM Planning Analytics Workspace, Jason Apwah discusses:

– The use of Planning Analytics as a tool to help users create predictive models and forecasts.
– Automation capabilities
– Incorporation of AI-infused demand planning that allows for improved forecasting accuracy in minimal time expenditure. 

AI-Infused Demand Planning Powered by TM1py, presented by Jason at Horizon 2022 

Meet Ben, Cubewise Consultant in Sydney Australia. He started by being an accountant by trade, worked as a financial auditor, then ERP systems to finally “accidentally falling” on the TM1 world.

For Ben, TM1 is more than just a tool — it is a time-saving application that has revolutionised his approach.  He confidently shares: “There is almost infinite possibilities with TM1”

In this episode of 15 minutes with…,  Jon Lee got a chance to talk to Cristian Blana, the new TM1 World Champion, winning the title at the TM1 Planing Analytics User Conference 2023 held in London.

Collaboration within a large organisation is as much an art as it is a science. Every team and division has a different view of the company and is chasing different objectives that align with their specific skills and mandate. As such, it can be challenging to get everyone pulling in the same direction. However, this is the key to making your business a juggernaut that makes the most out of the talent it has at its disposal.

When we look at the key aspects of interdisciplinary collaboration, perhaps the most important one is communication. If you aren’t able to communicate effectively across divisions, teams are never going to truly understand each other and be aligned in terms of what they’re trying to achieve.

Apliqo UX 2023 May release is here and it brings a multitude of exciting new features and improvements that take the application to new heights. From enhanced visualization capabilities to streamlined workflows, this release is packed with advancements across almost every aspect of the product. Let’s dive into the key highlights of this release.  

– Merge Widgets / Sub-Views vertically with shared column dimension
– Virtual / Helper dimension on filter bar
– Status bar for tables (Sum/ Average/ Count)
– Export to Excel as a slice with DBRW’s and Subnm’s
– Sandbox data entry
– Text Auto complete for settings service values (using Ctrl + Space)
– New chart types
– Improvements to: Cube Settings, Charts new advanced options, Subset Editor, Rollup Class and Wizard edit mode

Embrace the possibilities offered by Apliqo UX, from merging widgets and sub-views to enhanced exporting capabilities and a more efficient editing experience to unlock the full potential of your data analysis. 

Here’s an op-ed piece from one of our battle-tested developers, Robin Stevens.

Check it out! Here, she offers perspective on project management and model development, specifically, what to think about beyond the nuts and bolts of building a solution. 

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

Synchronise widgets at a group level
You can now synchronise widgets (explorations, visualisations, synchronisation tiles, selector widgets, and websheets) at the group level with group synchronisation. Previously, you could set the scope of synchronisation at the book or sheet level only.

Use the new experience dimension editor in books
The new experience dimension editor, which was previously available only on the modelling workbench, is now available in books.

Use subset calculations on the context section of a view
The subset calculation feature in the cube viewer has been added to dimensions on the context section of a view.

Use the new ‘Expand to’ and ‘Keep with’ options to organize members in a set
Expand to and Keep with have been added to the set editor. These new features display a set of members, based on hierarchy.

What’s new in plans and applications – 2.0.88

Duplicate applications and plans with attachments
The duplication feature in Applications and Plans has been enhanced to support attachments. When you duplicate an application or plan, any attachments in the original now automatically copy over to the duplicate. This is also true when you duplicate a section in Applications or task in Plans.

What’s new in modeling – 2.0.88

Create and insert custom snippets for processes
If you have TurboIntegrator process code that you use frequently, you can now save the code as a custom snippet. You can insert a custom snippet into the Script tab of a process

Access process error logs from the Databases tree
You can view or download process error logs from the Processes node on the Databases tree in a modeling workbench.

What’s new in administration – 2.0.88

Temporarily pause thread or activity refresh
A new Auto refresh option on the database page lets you control automatic thread or activity refresh. You can use this option to pause refresh when you want to examine database activity without being interrupted by updates.

What’s new in Deprecation notices – 2.0.88

Classic cube viewer to be removed from Planning Analytics Workspace 2.0.90
As of Planning Analytics Workspace 2.0.90, the classic cube viewer will be removed from Planning Analytics Workspace.

Known issues – 2.0.88

Imported data is not immediately visible in a reserved dimension
In a specific scenario, imported data is not immediately visible in a reserved dimension.

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 June 8, 2023 to include fixes and the following notices.

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.

Potential report integrity issue in IBM Planning Analytics for Microsoft Excel
IBM has become aware of a potential report integrity issue in Custom Reports and Dynamic Reports in IBM Planning Analytics for Microsoft Excel. Quick Reports and Explorations are not affected by this issue.

Upcoming change notification – Planning Analytics for Microsoft Excel to default to WebView2
 IBM® Planning Analytics for Microsoft Excel will default to using Microsoft Edge WebView2 in an upcoming release. WebView2 allows Planning Analytics for Excel to be compatible with newer web standards and technologies.

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 16 June 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.