I have a hierarchy for 0CUSTOMER info object with external chars. for Region, country and state which shows the customer information region-wise in the query result. Now I have created a hierarchy node variable with authorization type at query level. My requirement is to restrict a set of users to see a particular node values and for this, I have created a separate authorization object and assigned it a particular role. In that authorization object, I restricted few nodes which a user needs to access. But this is not exactly meeting my requirement.
For example, there are regions called Asia, Africa and Europe and the countries like India, Sri Lanka, South Africa, Zimbabwe,Germany, UK etc.. If a user has access to India values only, then he needs to see the aggregated value for Asia and for India as well. At the same time he should not see the individual values for other countries under Asia. How can I define an authorization object to make this possible. I have already tried with value authorizations and hierarchy nodes and the combination of both but nothing is working as per my requirement.
Thanks,
Shiva