topic Re: section access problem in QlikView

section access problem

Thu, 02 Aug 2012 15:38:10 GMT

Dear all,

I'm trying to use Section Access without success. I've this scenario:

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, Group

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, 07

USER, USER2, U2, 08

USER, USER3, U3, 06

USER, USER4, U4, 20

USER, USER4, U4, 21

USER, USER5, U5, *

];

User1 can see the group 07 only, ... user4 can see information about 20 and 21 groups...

The problem is that the data filtering doesn't work and I don't know why. When I open the document, user and password are required, but all the users

see all the information

Some questions:

"Group" is a field name: is it important if I write it in capitals or small ?

If I logged as user1, what happens if I press the loading botton ?

Thanks in advance for your help

Re: section access problem

cesaraccardi — Thu, 02 Aug 2012 16:38:26 GMT

Hi,

Have you checked one of the options "Initial Data Reduction based on Section Access" or "Initial Selection based on Section Access" at the Document Properties / Opening tab?

Regards,

Cesar

Re: section access problem

Fri, 03 Aug 2012 06:18:26 GMT

Please do what has been suggested by Cesar!

It's been very long since I worked on Section Access. But I guess you need to have Group in capitals.

To avoid the user to reload, please do the following:

Settings-->Document Properties-->Security(tab)-->uncheck: Allow User Reload

Hope it helps!

Re: section access problem

IAMDV — Fri, 03 Aug 2012 06:45:19 GMT

Hi,

I agree with Cesar. Please check the "Initial Data Reduction based on Section Access" and save the file. Also, I'm assuming that you are using SECTION APPLICATION statement after the INLINE table. Also, remove Section Access and directly link the Section Access table with the "Group" field and check if it behaves the way it should be...

Please read the documentation before you proceed further.

Cheers,

www.QlikShare.com

Re: section access problem

Fri, 03 Aug 2012 12:16:17 GMT

Hi,

I checked it, but data filtering doesn't work.

Re: section access problem

hopkinsc — Fri, 03 Aug 2012 12:20:34 GMT

Hi,

Is your 'Group' field lower or upper case in the other tables?

Make both UPPER case and see if it makes a difference.

Section access automatically converts to UPPER case but i can't remember if its just the VALUES or the fields also.

Re: section access problem

hopkinsc — Fri, 03 Aug 2012 12:21:25 GMT

Oh and after you have done that, reloaded and saved, you then need to exit and reopen the QVW

Re: section access problem

IAMDV — Fri, 03 Aug 2012 12:23:04 GMT

Field name don't have to be in UPPER case. Please make sure that all the values in Group field (Not Section Access) are in UPPER case. Because whenever you use INLINE table QlikView implicitly converts the SECTION ACCESS Table in to UPPER case. If this doesn't work then please post the sample application.

Thanks,

www.QlikShare.com

Re: section access problem

Fri, 03 Aug 2012 12:28:18 GMT

Please use UPPER(Group) and check...

Re: section access problem

Fri, 03 Aug 2012 15:09:22 GMT

Hi Deepak,

data filtering is working now.

Following your indication, I forced the upper case in my script and SA works properly.

For sure, you understood I'm a beginner and two question jump in my mind:

- I have read that "*" means all listed values. What does it means exactly, all the listed values into the section access ?

- If I want to have a user without any restriction, how do I have to insert it into the Section access table ?

Help again please

Thanks in advance

Stefan

Re: section access problem

hopkinsc — Fri, 03 Aug 2012 15:28:09 GMT

Hi Stefan.

I think you put a '*' into the Group field for that person, that should allow him/her to see all groups.

I'm not very good on section access but im 90% sure thats how it works.

I also think that making that person an ADMIN will stop all restrictions.

Hope it works!

thanks

Chris.

Re: section access problem

IAMDV — Fri, 03 Aug 2012 15:55:48 GMT

Answers :

1. From Help Documentation :

A wildcard, i. e. *, is interpreted as all (listed) values of this field, i.e. a value listed elsewhere in this table. If used in one of the system fields (USERID, PASSWORD, NTNAME or SERIAL) in a table loaded in the access section of the script, it is interpreted as all (also not listed) possible values of this field.

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.

In your Section Access example, you have specified Group values as {06,07,08,20,21} but if your actual Group field contains {06,07,08,20,21,30,31} then you won't see {30,31} rows even if the User has '*' in Section Access. It will ONLY take all the values from Section Access but not all the values from actual field.

I hope that makes sense.

2. I'm assuming that you are not using "Strict Exclusion". If this is the case then you need to leave the "Group" field blank to give Full User Access. The process is different if you are using "Strict Exclusion".

Cheers,

www.QlikShare.com

Re: section access problem

Fri, 03 Aug 2012 16:24:02 GMT

It's very very clear.

concerning the second question, I'm using "Strict Exclusion".

I n this case, do I have to build a table with all the combinations ? It seems a bit hard to manage

Gr.

Stefano

Re: section access problem

IAMDV — Fri, 03 Aug 2012 16:34:29 GMT

I'm glad to know that it makes sense.

Yes, you are right...makes me feel silly to psuedo code one user with all other possible options to provide full access, which is painful. But that's how it works unless I'm missing something important here. Also "Strict Exclusion" works fine with one field but if you have hierarchy table for Section Access implementation then it's going to be laborious job. I generally avoid using "Strict Exclusion" in Hierarchy - Section Access implementation. Rather I'll deal with it seperately with extra care but that's different topic for discussion.

You are not a beginner for sure...know your stuff!

Cheers,

www.QlikShare.com

Re: section access problem

IAMDV — Fri, 03 Aug 2012 16:45:23 GMT

I'll create video tutorials and post them on my blog. I'll update this thread whenever I do that...

Cheers,