topic Re: Complex section access bridge table not working in QlikView

Complex section access bridge table not working

Anonymous — Fri, 14 Mar 2014 22:01:22 GMT

Hi, I'm having an issue with section access when using multiple fields, I've followed the instructions in here:

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

open attachment on below comment to see script

I've have the initial data reduction checked, and I've tried both with strict exclusion and without checking it, same result...

It works just fine in my desktop qlikview, but once in the access point, it is not working

If I set my access to <ALL>|<ALL>|<ALL>|<ALL> it will let me see it, but if I replace any of the fields then it will say I don't have access, for example <ALL>|PPS|<ALL>|<ALL> (but in desktop I do have access and it reduced to PPS only)

Thanks in advance for your help!

Re: Complex section access bridge table not working

stabben23 — Sat, 15 Mar 2014 20:27:36 GMT

Hi Oscar,

I don´t know but you have a lot of startbrackets that dont have a endbracket in the Bridge part. You also have a endbracket in performance.

Re: Complex section access bridge table not working

Sat, 15 Mar 2014 20:48:29 GMT

Hi Oscar,

Can you please share an sample application with sample data to work with.

Regards,

Vasim

Re: Complex section access bridge table not working

Anonymous — Sat, 15 Mar 2014 22:11:02 GMT

Hi, thanks for your help, the brackets is my bad, I tried to simplify the script to post the question. I'm attaching the file, the whole load scripts are there. I've commented the section access script and unchecked the reduction and strict exclusion so you can open the document.

Re: Complex section access bridge table not working

Sat, 15 Mar 2014 22:46:08 GMT

Hi Oscar, Please check the section access table have the ADMIN QVSERVICE account name ?

Re: Complex section access bridge table not working

Anonymous — Sun, 16 Mar 2014 03:46:13 GMT

Hi Dathu, Im not sure what you mean, I do am including a system account, the one that runs the refreshes, as I'm not an admin and this process is driven by a external team.

Sent from my Samsung Mobile

Regards,

Oscar Marquez

Re: Complex section access bridge table not working

Sun, 16 Mar 2014 17:31:32 GMT

Hi Oscar,

Thanks for sharing the file.

But when i am trying to open your document ,i get this error of failed to open the document.

Regards,

Vasim

Re: Complex section access bridge table not working

Anonymous — Sun, 16 Mar 2014 17:48:04 GMT

Hi Vasim,

I'm not sure why you would get that message, unless you have a personal license, I've deactivated data reduction and strict exclusion, also I refreshed it without section access before uploading it. Any ideas?

Re: Complex section access bridge table not working

Sun, 16 Mar 2014 20:01:23 GMT

Hi Oscar, I am suspecting the %KEY Section Table having the same data in BridgeTable.

Please check the data in new qvw file.

Please provide the sample data for your script.

Re: Re: Complex section access bridge table not working

Anonymous — Sun, 16 Mar 2014 20:24:55 GMT

Hi Dathu,

Here's the attachment with the files I'm using. I'm not really sure what you meant with "same data". Thanks for your help, I really appreciate it.

Re: Complex section access bridge table not working

Sun, 16 Mar 2014 22:30:40 GMT

Hi Oscar, your script looks good and exact error you are getting on the Access Point ?

Access Denied Error ?

Re: Complex section access bridge table not working

Anonymous — Mon, 17 Mar 2014 02:16:16 GMT

Hi Dathu, yes, I'm getting the access denied error

Sent from my Samsung Mobile

Regards,

Oscar Marquez

Re: Complex section access bridge table not working

Anonymous — Mon, 17 Mar 2014 22:15:15 GMT

Any idea? 😕

Re: Complex section access bridge table not working

Anonymous — Mon, 24 Mar 2014 08:39:15 GMT

Yes I have an idea. When you say 'all' in the Section Access table it means all of the values in that Section Acces table. So in your case all the regions, all the BG, all the BU and all the segments who are listed in the section access table . If you put ALL in all fields Qlikview is able to assemble a database for you. Note that in the BU field the only value in the list is 'TS'. So when you put 'PPS' in the field BG, Qlikview can't make a database since PPS and TS exclude each other. Please put in a blank for all fields instead of ALL for you as administrator. In this case you will get to see all 🙂 and not only all fields listed in the access list.

Re: Complex section access bridge table not working

ksmith24 — Fri, 10 Oct 2014 20:23:16 GMT

I am seeing this also, works using local client but if the server reloads and publishes, "access denied". Were you able to figure anything out here?