topic Re: Section Access help in QlikView

Section Access help

hopkinsc — Wed, 10 Oct 2012 13:27:37 GMT

Hi everyone.

I am trying to set up section access, it works as expected if i open the document from the desktop client but it doesn't work on the server.

The server version is 11.0.11282.0

and the client version is 11.11414.0 SR2 64Bit

I have hardcoded 2 ADMIN logins in the Section Access inline load

Userid Password

Admin Admin

User1 User1

I have attached the files i am using, could somebody please take a look to see what i have wrong.

Thanks

Chris

Re: Section Access help

Miguel_Angel_Baeyens — Wed, 10 Oct 2012 13:38:11 GMT

Hi Chris,

The issue is that the "*" does not mean "all possible values" rather than "all listed (specified) values in section access". In the field "Business Unit Code" that is present in the section access because of the JOIN, some users do not have any value, therefore they do not have access to the document. You either do the JOIN after concatenating both tables or even better, you load the first table without loading the bussiness unit code (note that names must be UPPERcase in section access).

Hope that helps.

Miguel

Re: Section Access help

hopkinsc — Wed, 10 Oct 2012 13:50:05 GMT

Hi Miguel,

Thanks for the reply.

I don't understand though.

The section access works from the desktop client, I don't understand why the join would not work in the server?

Re: Section Access help

Miguel_Angel_Baeyens — Wed, 10 Oct 2012 14:24:46 GMT

Chris,

The problem is not the JOIN, that will work in the Server as well. The issue is that in Desktop, either "*" or " " (blank) will grant you access to the application if you are an ADMIN or you don't have "Strict Exclusion" checked in your Document Properties, Opening tab.

But as a client you are always a USER, even if you hardcoded ADMIN in the ACCESS field in the section access table, therefore there are no valid "*" unless all values for that field have been specified beforehand.

Hope that makes sense.

Miguel

Re: Section Access help

hopkinsc — Wed, 10 Oct 2012 14:25:28 GMT

Hi all, could anyone change the examples for me to see what is needed to be done to be fixed?

Re: Section Access help

hopkinsc — Wed, 10 Oct 2012 14:48:47 GMT

Hi Miguel,

I can see that you have renamed the field to uppercase and added the same field to the inline table.

Everything works from the QV client but NOTHING works from the server.

I am confused with the "*" values. do i need to change them in the spreadsheet? I thought having a "*" allows the user to see all values in the dataset? therefore when userid MLOM logs in, he\she would see access region B which means he/she will have access to 5 business unit codes?

And i know that section access is uppercase, but if the field itself is lowercase how would that work.

i.e. Business Unit code in the data is lower case so how would the UPPERCASE section access field link to it?

Thanks

Re: Section Access help

Miguel_Angel_Baeyens — Wed, 10 Oct 2012 15:20:25 GMT

Hi Chris,

Yes, the "*" means that, at least one user (usually an ADMIN) must have one line for each field value.

Note that I changed uppercase the name of the field from the excel file as well. This model is actually working right in my computer desktop and server.

Hope that helps.

Miguel

Re: Section Access help

hopkinsc — Wed, 10 Oct 2012 15:52:39 GMT

ok thanks, i will try that. there was no excel file attached to your reply so i assumed it was left as is.

Re: Section Access help

hopkinsc — Wed, 10 Oct 2012 16:07:51 GMT

hi miguel,

I now have it working on the server using the hardcoded userid's and the ones in the spreadsheet, but i cannot get the NTNAME to work.

and when i log in successfully (Using an id and password, and from the accesspoint on my local machine), if i type in a text box =osuser() the NTNAME of my server login appears not the NTNAME of my local machine.

Any ideas why that is happening?

Re: Section Access help

hopkinsc — Thu, 11 Oct 2012 07:43:09 GMT

Can anyone help with the NTNAME query please?

Re: Section Access help

hopkinsc — Thu, 11 Oct 2012 14:42:16 GMT

does anyone have any ideas why my server ntname is being used in my accesspoint on my local machine? it is stopping section access working.

Or am i missing something?