Section Access with multiple fields

[amars]

Hi all,

We are designing a Section Access for an application, below is the data that we wish to achieve through section access.

USER ID     Department     Group     SubGroup     EmployeeType

A                Finance            *             *                    Manager

A                IT                     *             *                    Developer

B                IT                     Abc         xyz                Manager       

Now after implementating the security we found that the user expecting

User A to see only Manager's in Finance & Developer's in IT

but the Security that I have implementated shows all Developer's & Manager's in IT & Finance (as can be seen after applying the Initial Selection based on section access property ).

All the fields mentioned above are present in the Section Access and in Section Application only line present is * is Star.

I thought to implement a composite key of all the fields but * may occur for all the fields sometime, which prevents me from using a composite key.

Please suggest how this could be achieved.

Thanks in Advance.

Amar

[hic · Accepted solution]

You need to use Generic keys. See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

and on

http://community.qlik.com/docs/DOC-3451

HIC

[IAMDV]

Hi Amar,

Please follow what HIC suggested and that should take care of your requirements.

Also, another alternative approach would be implementing Section Access at the most granular level of your data. Which will eventually roll-up based on the Hierarchy.

Also, please be very careful using the '*' (Wildcard) because it doesn't mean all the values in the Actual Field. It means distinct values you have specified in Section Access Table. Unless you have specified all the distinct values within Section Access.

Please read this thread for detailed information and example:

http://community.qlik.com/message/247356#247356

Good luck!

Cheers,

DV

www.QlikShare.com