topic Section Access in QlikView

Section Access

vijetas42 — Wed, 27 May 2015 14:31:59 GMT

Hi all,

We have issue with files on which we applied section access.on accesspoint it's showing error like,

failed to open document.previously they works fine.please find attached screenshot.and give your solutions.

We also check section table for all users we have entry in it.

Thanks!

Re: Section Access

Qrishna — Wed, 27 May 2015 14:36:50 GMT

Hi Vijetha,

This message shows that the user is not authorized to see the document even though that user exists in the section access.

so check the User whether the user is authorized to see the doc or not.

let me know if you have any questions.

Thanks

krishna

Re: Section Access

Clever_Anjos — Wed, 27 May 2015 16:07:23 GMT

It seems that the user you are using to open the QVW is not in Section Access section.

Please use one user that is in SA or use a backup, there´s no workaround

Re: Section Access

Anonymous — Wed, 27 May 2015 18:39:54 GMT

Hi Vijetha,

You say "previously they works fine" was it before you applied section access

or it was working fine with the QlikView desktop client ?

May be this will help you, please take a look at this https://community.qlik.com/docs/DOC-8633

Here is an extract:

In this example the QlikView Server service account and the application developer are expected to get all values in field F1. The application end-user on the other hand has limited access to the field F1.

On server side the work-flow will be a bit different, potentially leading to unexpected results for the User.

Application is opened by the Service user
Application is reloaded by the Service user
Data in the QVW file is reduced based the Service user reduction value
Application is saved to QVW file by the Service user
QVW is distributed

The distributed QVW file now has reduction values that matches the Service user. In this case it means that REDUCTION field only has ALL as possible value. The User's reduction value A does not exist, and this can lead to two different outcomes when the User opens the application through a web client.

If Section Access: Strict Exclusion is enabled, the User gets access denied since there is no possible data for the User.

Basically the Service User needs to have access to all reduction values, so that it covers all the users needs. By using wildcard star the reduction is equal to all listed values in the section access table.

Regards,

Luc