topic Re: Section Access: Combining Field Reduction and OMIT in QlikView

Section Access: Combining Field Reduction and OMIT

jarno_loubser — Tue, 17 Feb 2015 06:35:23 GMT

I already know that what I want to achieve is not possible using Section Access, but describing the issue with reference to section access seams easiest.

Data Source: HR

Section Access Field Reduction: EmployeeID

Section Access OMIT Field: SalaryAmount

I need to cater for the following scenarios:

UserA logs in a sees Employee1, Employee2 and Employee3. He also sees SalaryAmount for all three employees; - No Problem here
UserB logs in a sees Employee1 and Employee3. He also sees SalaryAmount for Employee1 and Employee3; - No Problem here
UserC logs in a sees Employee1 and Employee3. He does not see SalaryAmount for Employee1 and Employee3; - No Problem here
UserD logs in a sees Employee1, Employee2 and Employee3. He also sees SalaryAmount for ONLY Employee1 and Employee3; - Problem

As I said – I am aware that OMIT will hide the field (or not) for the user on all records or none.

The question: can anyone think of a way to achieve the goal keeping the following in mind:

The Salary Table can have many millions records;
The field need to be hidden ‘n such a way that a self-service user must not be able to get to the values;

Re: Section Access: Combining Field Reduction and OMIT

tresB — Tue, 17 Feb 2015 06:53:59 GMT

If you have Publisher, you can reduce the application on bookmark of your choice. The reduced application doesn't contain left out values(literally 'reduced' ).

Re: Section Access: Combining Field Reduction and OMIT

jarno_loubser — Tue, 17 Feb 2015 07:13:15 GMT

Tresesco

The problem I have is not hiding rows, but hiding (OMIT) a field, for certain rows. See scenario 4 in my problem statement.

Re: Section Access: Combining Field Reduction and OMIT

jonathandienst — Tue, 17 Feb 2015 07:34:03 GMT

Have a look at these blog posts:

Generic keys

Data Reduction Using Multiple Fields

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

Basics for complex authorization

They should help you find the correct approach.

HTH

Jonathan

Re: Section Access: Combining Field Reduction and OMIT

jarno_loubser — Tue, 17 Feb 2015 07:57:34 GMT

jontydkpi

Perhaps I misunderstand your post, but I fail to see how any of those links will help me achieve my scenario 4 in the problem statement?

Let me restate the issue:

How do I show a user a SalaryValue field for certain employees, but not for others. It is not about hiding the row as the employee must still exist in the reduced dataset, but the SalaryValue field must be available on only some of the rows in the users already reduced dataset.

Re: Section Access: Combining Field Reduction and OMIT

tobias_klett — Tue, 17 Feb 2015 07:59:59 GMT

Hi Jarno,

forget about the OMIT. What you really want is to reduce the Sales Table differently from the Employee Table. Therefore you need a Link Table for your different Rights like this:

Hope this helps.

Regards Tobias

Re: Section Access: Combining Field Reduction and OMIT

jarno_loubser — Tue, 17 Feb 2015 08:27:39 GMT

Hi Tobias,

Thank you - I will test and report back!

Re: Section Access: Combining Field Reduction and OMIT

jarno_loubser — Tue, 17 Feb 2015 08:31:34 GMT

Hi Tobias,

It works - Thank you!!