topic Dynamic Data Reduction based on Section Access (multiple data values from a single field) in QlikView

Dynamic Data Reduction based on Section Access (multiple data values from a single field)

Wed, 24 Mar 2010 04:34:47 GMT

I am trying to implement data level security in my qlikview application.

The users can have different priviledges depending upon their business profiles and roles. The data security rules are defined per user.

Example:

ACCESS NTNAME Rule

USER userA Consumer Products

USER userB Retail, Consumer Products

USER userC Real Estate

USER userD Industrial, Retail

USER userE Industrial

.........

........

.......

In the data model, the rules for entitlements are based on data values (Real Estate, Retail, Industrial, Energy...) from a single Field (INDUSTRY).

A user may be entitled to a specific industry, another user may have entitlements for three industries. The possible number of such combination rules is not currently defined and I am not is a position to create separate flags in my data for the different buckets of data values which are possible.

I know, OMITFIELD allows multiple fields to be mentioned as comma separated values within section access to restrict fields from being shown per user. Is there a similar logic which can be implemented to entitle users to view multiple data values from a single field.

Kindly let me know if anybody on the forum has implemented something like this, or any other implementation which you can think of.

Appreciate your help!

Thanks

Rakesh

Dynamic Data Reduction based on Section Access (multiple data values from a single field)

sparur — Wed, 24 Mar 2010 08:41:16 GMT

Hi, Rakesh.

I think you should create 2 tables. the first table is:

ACCESS NTNAME GROUP

USER userA 1

USER userB 2

USER userC 3

......

The second table is:

GROUP INDUSTRY

1 Consumer Products

2 Retail

2 Consumer Products

3 Real Estate

....

the first table you shoud to load in Section Access

and the second table - in section application.

Dynamic Data Reduction based on Section Access (multiple data values from a single field)

Wed, 28 Apr 2010 16:34:05 GMT

Hi Sparur, Your method works for having 1 value in the INDUSTRY field. Is there a way where you can have it not filter by INDUSTRY for a user?

Here is what I am trying to do:

GROUP INDUSTRY SUBINDUSTRY

1 Consumer Products Product A

2 Retail <I do not want to filter here by SUBINDUSTRY>

Is there a way for in group 2 to not filter the SUBINDUSTRY? If I leave it blank then when the data is reduced there are no values in the SUBINDUSTRY field.

Thanks

Dynamic Data Reduction based on Section Access (multiple data values from a single field)

Wed, 01 Dec 2010 16:05:42 GMT

Hi,

I don't know if you still need an answer for this, but i'll post it anyway for other people who might have the same problem. I was looking for the answer to this exact same question and discovered the solution by accident.

As far as i've found: listing multiple values seperated by comma is not possible. You need to ad a line to your table for each value the user can see. for your example, the table you want to load as your section access will be:

ACCESS NTNAME Rule

USER userA Consumer Products

USER userB Retail

USER userB Consumer Products

USER userC Real Estate

USER userD Industrial

USER userD Retail

USER userE Industrial

.........

Regards,

Yves.