Skip to Content
0
Sep 08, 2023 at 08:04 AM

script to expandNode: error for waterfall chart - bar chart OK [live BW conn.]?

39 Views

Hi,
I wanted to collapse/expand hierarchy nodes in a waterfall chart according to user actions (collapse/expand hierarchy) in a table (both same live model & same dimension).
It seems that used script is OK for bar charts but will result in an error if used for waterfall charts:

// Open parent and 1 child node for testing purposes
Chart_1.getDataSource().expandNode("0GLACCEXT", {[Alias.MeasureDimension]: "00O2TH23Y2YIR176LSWVBH68N", "0GLACCEXT":"0HIER_NODE!IRG 3001000"});
Chart_1.getDataSource().expandNode("0GLACCEXT", {[Alias.MeasureDimension]: "00O2TH23Y2YIR176LSWVBH68N", "0GLACCEXT":"0HIER_NODE!IRG 3001001"});

error waterfall chart:

image.png

waterfall designer view (same as for bar chart):

image.png

Anyone has an idea how syntax needs to be changed in order to work for waterfall charts too?
thank you & have a nice weekend.
regards
edgar

Attachments

image.png (14.7 kB)
image.png (16.3 kB)