topic Re: Section Access help in QlikView

Section Access help

hopkinsc — Wed, 13 Jun 2012 09:09:38 GMT

Hi all,

I need some help with section access please. I have attached my files, I am loading in an inline table plus a security spreadsheet, but i can't get it to accept anything from the spreadsheet even though it IS loading the data into the QVW.

Can anyone help please?

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 10:07:10 GMT

Anyone have any ideas please?

Re: Section Access help

Wed, 13 Jun 2012 10:20:19 GMT

the example file you have uploaded you will need to add an *,admin, admin,*,* to so people can check the load script.

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 10:24:54 GMT

Hi , thanks for your reply. I have a user in the password file ... 'chris' who is admin.

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 10:28:14 GMT

But i have just amended the file to include ADMIN,ADMIN too.

Thanks

Re: Section Access help

RedSky001 — Wed, 13 Jun 2012 10:33:25 GMT

Can you be a more descriptive with the problem you are having.

I have loaded the dashboard and can login with the user TEST4 password QV which is in the spreadsheet.

Mark

Re: Section Access help

Wed, 13 Jun 2012 10:35:46 GMT

Hi I have reloaded the data and I am logging in as TEST0 and QV without problem, ensure you are using uppercase when logging on as section access uppercases login id's

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 10:44:29 GMT

Hi, thanks both for looking.

It seems that it is accepting some id's but not all.

Some of the ones not being accepted are :

CM007, QV

CH004, QV

JB050, QV

AK150, QV

SUTTON, SUTTON (although i think that is because the NTNAME isnt found)

Also, my NTNAME is at the bottom of the spreadsheet, but it keeps prompting me for a useris and password.

I believe you can enter the USERID ans upper or lowercase. - i have tried both anyway with the above names with no success.

Re: Section Access help

Wed, 13 Jun 2012 10:54:52 GMT

I think this is down to the spelling, it is CMO07 not CM007 etc, its a ltter not a number

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 11:01:10 GMT

Hi, it seems you are right regarding the CM007 and CH004. but its not right for the other 2 or my NTNAME.

The only difference i can see is that there are *'s for those 3 for COUNTRY and PROJECTCODE.

I want those users to see ALL COUNTRIES/PROJECTCODES.

Re: Section Access help

Wed, 13 Jun 2012 11:30:18 GMT

I think it may be down to you having \ in your NTNAME you should have /

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 11:44:34 GMT

I have just tried that but it didn't work.

I am sure the \ is correct as this is what is returned when using osuser() in a text box..

Re: Section Access help

Wed, 13 Jun 2012 12:28:12 GMT

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTNAME

ADMIN, ADMIN, ADMIN,

ADMIN, , , IP-0A3149BC/FSHANAGHY

];

Section Application;

this is working for me.... odd

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 12:31:11 GMT

I need it to work from the spreadsheet. Could it be to do with the * 's in the spreadsheet?

If i use the NTNAME in the inline table it works fine.

Re: Section Access help

Wed, 13 Jun 2012 12:34:34 GMT

You should leave the * out in section access * means every forementioned value so just leave the value blank if you want all values.

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 12:36:09 GMT

Hi, so you are saying that the spreadsheet shouldnt have any * 's in it at all?

Re: Section Access help

Wed, 13 Jun 2012 12:38:33 GMT

Correct If you want all values they are not required

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 12:49:08 GMT

Hi, i removed the * 's but still no joy. it keeps asking for login details.

Re: Section Access help

Wed, 13 Jun 2012 13:06:18 GMT

This appears to work, oddly you need * in the password (or alternatively a password) the * bypasses it

Re: Section Access help

hopkinsc — Wed, 13 Jun 2012 13:12:11 GMT

Again,it didn't work for me, and i can't even open your QVW - Acess denied with no USERID prompt