Skip to Content
author's profile photo Former Member
Former Member

User Access Rights in Hierarchy Nodes BEx Query

Hi experts,

have been researching for a while, but seems a bit difficult to find the answer to my issue. So I have a query which uses hierarchical reporting and I would like to restrict different users from looking at different node values in diffierent levels for ex.

Cars (Level 1)

Model X (Leve 2)

Type X1 (Level 3)

Model Y (Level 2)

Type Y1 (Level 3)

So user X should see only Model X and its child nodes. User Y should see only Model Y and its child nodes. Finally, User Z should se the whole hierarchy like it is above.

I know one solution is to restrict the hierarchy in the query, save the query and publish it to the Role that this user is assigned. However this is not flexible if there are 100 users and each of them has to access a specific node value in the hierachy. If following the above approach, this would mean to create 100 Roles and 1 user for each role.

Could anyone please suggest any possible solution for the above scenario?

With Best Regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 09, 2016 at 06:08 AM


    For our HR reports we use a customer exit variable reading a DSO, where each user has his org unit and the ESS/MSS parameter assigned to it, ESS meaning only the org unit it self and MSS all the org units beneath the specified org.

    In this way the users are only able to see allowed data. The hierarchy will only show posted values.



    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.