topic Re: Section Access in QlikView

Section Access

Thu, 06 Dec 2012 14:49:00 GMT

Hi there Qlikview community,

I am having some problems on using section access in order to give certain views to different users.

my hidden script table is shown above

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, VALIDATORUNIT

nkavroulakis, nkavroulakis, george55, BM200

TestUser, TestUser, 1234, BV50

];

All my records in VALIDATORUNIT are uppercase but still not loading any data at all.....
Any ideas????

Thank you in advance.

Re: Section Access

hic — Thu, 06 Dec 2012 14:58:39 GMT

The ACCESS column should have the value ADMIN or USER.

HIC

Re: Section Access

Peter_Cammaert — Thu, 06 Dec 2012 14:59:28 GMT

Data in column "ACCESS" must be one of USER or ADMIN. Other values will cause those rows to be ignored.

Best,

Peter

Re: Section Access

Thu, 06 Dec 2012 15:11:20 GMT

Still not working although altered my script like this:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, VALIDATORUNIT

ADMIN, nkavroulakis, kavros14,

USER, TestUser, 1234, BV50

];

Re: Section Access

Peter_Cammaert — Thu, 06 Dec 2012 15:23:31 GMT

Remember, Section access tables won't show up in your document. They will grant/refuse access, reduce data if needed, manage initial selections and so on. But you will never see a table containing usernames and passwords.

"...but still not loading any data at all..." What exactly is happening in your document? Is everything reduced away?

Best,

Peter

Re: Section Access

hic — Thu, 06 Dec 2012 15:24:46 GMT

Do you get all data or no data?

Make sure that

Document properties -> Opening -> Initial data reduction etc. is set
All field names and all field values in Section Access are upper case

HIC

Re: Section Access

Thu, 06 Dec 2012 15:26:58 GMT

Yes it is propable reduces all information away.....and leaves it blank

Re: Section Access

Peter_Cammaert — Thu, 06 Dec 2012 15:31:53 GMT

Are you sure you have fields with identical names in both Section Access and outside to link your SA to the rest of the data?

See also Henric's remarks about case below.

Peter

Re: Section Access

hic — Thu, 06 Dec 2012 15:34:56 GMT

A good debugging method is to just comment out the "Section Access" statement. Then you will get the section access table as a normal table and you can often see what goes wrong.

HIC

Re: Section Access

Thu, 06 Dec 2012 15:49:09 GMT

Yes its alla set in document properties still no results

Re: Section Access

Thu, 06 Dec 2012 15:54:50 GMT

It says the script execution failed and then when i try to run my file asks password....but still when i give the admin password no data visibilty at all.

Should i attach my qvd file ????in order to have a look???

Re: Section Access

Thu, 06 Dec 2012 16:13:48 GMT

Yes i am sure

Re: Section Access

Thu, 06 Dec 2012 16:15:56 GMT

It says the script execution failed and then when i try to run my file asks password....but still when i give the admin password no data visibilty at all.

Should i attach my qvd file ????in order to have a look???

Re: Section Access

IAMDV — Fri, 07 Dec 2012 13:12:17 GMT

Hi,

Please attach your QVW file and one of us can look at the script. Meanwhile, can you make sure that you have used UPPER() function on VALIDATORUNIT field. Not just in the Section Access script but the actual field reduction should be in Upper Case. That could be the reason you are seeing NULL values.

However, please share the QVW & QVD files and I'm sure we can easily sort out for you.

Good luck!

Cheers,

www.QlikShare.com

Re: Section Access

Fri, 07 Dec 2012 15:34:08 GMT

As i mentioned before i used the hiddent script :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, VALIDATORUNIT

ADMIN, nkavroulakis, george45, NV200

USER, TestUser, 1234, BV50

];

To give diffrent access to users but it does not seem to work i get blank file.Can you check what is the potential error...

Re: Section Access

Mon, 10 Dec 2012 12:28:51 GMT

Does anyone has any ideas..anything i tryied does not seem to work...:(

Re: Section Access

Peter_Cammaert — Mon, 10 Dec 2012 15:24:01 GMT

Thanks for this example.

I did an export of your data (a single table called Validators_Boundaries) to a file called VB.QVD. Then I made a new model with some listboxes, and a script that does two things:

1. Load the SA INLINE table (missing from your example qvw) with the code from your comment immediately above mine.

2. Perform a LOAD of VB.QVD

Enabled both "Initial Data Reduction Based on Section Access" and "Strict Exclusion".

This model works without a problem. See the attachment, this one has a disabled SA. To test it yourself, make a copy of this file (like "TestSA Secured.qvw") enter the script and remove the comment markers from the first line. Reload, save the qvw, restart QV and load the new file. Use the above credentials (in UPPER CASE) to enter the newly secured model.

You didn't forget to put Section Application; somewhere in your original script by any chance?

Best,

Peter

Re: Section Access

Anonymous — Tue, 28 May 2013 10:53:10 GMT

HI Nikolaos,

don't know if you've already fixed but the really "misterious & magic trick" for me is point 2 of Henric Cronström suggestion : all fields must be UPPERCASE.

You can setup anything in the correct way but without this little hint .. it won't work :O)

Best regards,

Fabrizio