Planning Analytics Deep Dive with Andrew Leighton - Waterfall Charts

Описание: Chapters
0:00 - Intro
0:45 - Classic Waterfall Chart
1:22 - MDX for Classic Waterfall Chart
1:55 - Free Trial offer of Arc for TM1
2:42 - Setting Up Classic Waterfall Chart
4:02 - Bridge Waterfall Chart Overview
4:35 - Field Settings for Bridge Chart
5:17 - Advanced Selector Widget
5:35 - Conclusion

Aloha and welcome to another episode of the Planning Analytics Deep Dive! 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)'

For more information head out to www.cubewise.com

#dogoodtm1