Skip to Content

Filter Hierarchy in Lumira Designer 2.3

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

gl.jpg (35.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Oct 30, 2019 at 01:26 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2019 at 02:50 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 05, 2019 at 10:16 AM

    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");
    
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 06, 2019 at 01:17 PM

    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.


    hier.jpg (73.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.