Filter Hierarchy in Lumira Designer 2.3

[former_member606476]

Hello,

I am working on a report, where we want to filter one node of the hierarchy to show all the accounts but not 6 accounts(attached).

We would like to apply filter or hide these 6 rows.

I have tried to apply the background filter in initial view, however as soon as the hieracrchies are applied on the account column. The filter goes away and those 6 accounts gets visible again.

It would be great if you can direct me to a solution for this.

Thanks,

Ritesh

gl.jpg

[former_member606476]

Thanks a lot for your answer and some hope that this issue can be solved.

The next problem, I am currently facing is putting the right syntax in Initial View Editor

It would be great if you could provide your help identifying the right syntax for this.

Requirement is to exclude the last six accounts highlighted in Image.

[reiner_hille-doering]

Of course you can filter hierarchy nodes in Lumira. However if you activate or deactivate a hierarchy or switch to another one, it might be perfectly possible that filters are reset.

Thus you need to apply the node filters after you have activated the hierarchy.

Either you do everything in Initial View Editor - or you script the necessary filter operations. E.g.

DS_1.assignHierarchy("ID", "Employee_Level_hierarchy_2");
DS_1.setFilter("ID", "HIERARCHY_NODE/CONTINENT/America");

[former_member606476]

While clicking on "Select Hierarchy", the filter gets removed and I see all the 6 accounts in rows.

My problem is similar to this

https://answers.sap.com/questions/12324583/hide-specific-leafs-and-parents-from-a-hierarchy.html

One of the user has mentioned,"

the default behavior of Design Studio is that when the node has been selected, the children are available as well for the drill down.

so in the crosstab the node is shown and the user has the option to open up the node to see the next level and in your case because you select the top node, the other elements are included as well."

Is this true, that we cannot filter or hide, particular nodes in Lumira Designer ?

Thanks,

Ritesh

[reiner_hille-doering]

You should try to find out which actions removes your filter. Place a Filter Panel or Filter Line into your app and monitor in which moment the filter for your individual nodes are removed.

Some operations (e.g. Drill-down Hierarchy in context menu) clean filters, as they are needed for the corresponding navigation. You should try to avoid such operations and instead do the needed navigation with script that keep your filter set.