Skip to Content
0
Sep 19, 2023 at 11:40 AM

How to expand all nodes of a dimension hierarchy in a table in SAP Analytics Cloud

116 Views Last edit Sep 19, 2023 at 12:27 PM 4 rev

Hi all.

I need a way for user expand and collapse all hierarchy nodes in a table, I have managed to do that using the script where I call this method:

DataSource.expandNode(dimension: string|DimensionInfo, selection: Selection)

It is working fine, but it allows to expand just only one node, so to expand all nodes, I am doing a loop where I go to each node and expand it, but it has a bad performance, so I would like to a way to pass all nodes of a dimension, in the selection parameter for example, and expand all of them using just only one call of expandNode method of DataSource class for example.

Thanks and best regards.