Authorization - User with multiple Titles.

sogloqlik — Fri, 02 Apr 2021 08:14:01 GMT

Hi,

I have the Following Requirement:

In our Sales model, We Have authorization levels, Meaning some users can see the whole data (For example: Gross Sales, Discounts and Net Sales) and some Users can see only the gross sales.

The problem is that some users have multiple titles: As a trade manager the can see the entire date for the relevant customers and as Sales area managers they can see only the Gross sales for the relevant customers. Those customers are NOT always identical.

I can't use OMIT, can't use data reduction and many reports are sent by the NPrinting so I need The NPrinting to consider those limitations.

Any ideas?

An example is attached.

Re: Authorization - User with multiple Titles.

andoryuu — Thu, 26 Dec 2019 15:02:24 GMT

If you're using section access we've found that you can only use data reduction to show the intersection of data ("and" instead of "or"). We've addressed this by having our section access query identify their highest level of security and grant that and communicated to management that it's can't be "Give me location 'a' and dept 'b'", but it can be "Give me title 'a' and title 'b'". Same reduction field = "or", but multiple reduction field = "and".
If you're using NPrinting and users aren't accessing the app directly your best solution would be to provide multiple reports. The other option would be to create a central linking/fact table that unifies all of your permutations of the various security attributes and has data reduction fields based on the appropriate intersection of values.

topic Authorization - User with multiple Titles. in App Development

Authorization - User with multiple Titles.

Re: Authorization - User with multiple Titles.