Aloha and welcome to another episode of the Planning Analytics Deep Dive with Andrew Leighton! In this video, Andrew will guide you through creating Waterfall charts in Planning Analytics Workspace. We’ll cover both Classic and Bridge types, leveraging TM1py and MDX. Learn how to visualize changes across dimensions and create dynamic, insightful charts. Stay tuned for practical tips, useful links, and a comprehensive walkthrough.

Useful links:

Waterfall Chart Enhancement Request with IBM https://ibm-data-and-ai.ideas.ibm.com…

Arc for TM1 Free Trial https://code-develop.netlify.app/down…

Useful code from this episode:

WITH MEMBER [MeasureDim].[MeasureDim].[Waterfall] AS        
STRTOVALUE([RowDim].[RowDim].CurrentMember.Properties("MEMBER_WEIGHT")) *        [MeasureDim].[MeasureDim].[Amount],       SOLVE_ORDER = 1, FORMAT_STRING = '#,##0;(#,##0)'