Waterfall Charts - BW Live Connection
Hi fellow SAC journeymen/women & experts,
I have been seeing plenty of interest in the market for SAC and it is wonderful to see SAP having a answer (sort of) to PowerBI and Tableau.
I have been working with BW Live connections so far on most of my projects and one of the things that is a bit difficult to do is - Waterfall charts.
Waterfall charts have been ok when it comes to a single measure (and as defined by SAP - two dimensions), but I have always been stuck when you need a waterfall chart for variance analysis - NPAT Plan to NPAT Actuals comparison scenarios with Price, Volume and FX effects being shown.
I can achieve the requirements in BW Queries using cell definitions for cross calculations, but hamstrung when it comes to using these figures (Multiple measures in BW Queries) in to SAC stories.
Anyone has had any success with these kind of scenarios?