How to generate Price Waterfall with HANA

[Former Member]

Tried creating a price waterfall using HANA default waterfall charts as well as BO explorer provided on sandbox. But not successful so far. HANA waterfall chart by default generates waterfall using a specific measure across a multiple values in a single dimension. But the requirement is to generate a price waterfall across multiple price points with drill down/ filter capability across multiple dimensions or attributes. Any thoughts or suggestions on this requirement.

The next observation within HANA or BO Explorer, a custom calculated measure can be generated with a simple caculation involving only 2 measures but will not allow more than that. Is there a way we can generate a complex calculated measure similar to cumulative calculation across a specific set of aggregated measures.   Again any suggestions or thought process in this regard will help.

And I don't see any velocity curve chart available. I expected to see more in built functions be available as part of the standard tool but I do see only basic functions like sum or count. Am I missing any documentation in this respect.