I am facing a problem with the authorization of security (data reduction) where I have only QlikView Server (No publisher).
I am using section access with NTNAME, ACCESS, and Fields I want to reduce the data from, I have used everything in upper case (FIELDS as well as VALUES in it), checked the "initial data reduction....." in document properties - opening tab.
After reload, When I open it from QlikView Desktop it works as it should (means reduction applied properly and section access works fine), but when I access the same document from access point it says "Access denied for the user".
Any help would be highly appreciated as it is URGENT and IMPORTANT.
I have to reduce the data on three fields user wise i.e. Deposit_Group (Table: Dep), Region (Table: GeoDist) and Cluster (Table: GeoDist)
I have done the following for Section Access application.
First I made three resident link tables to have values and column names in upper case and to avoid the synthetic and circular references since two fields are coming from one table (GeoDist) that is the reason I have made link tables and not directly put the data model fields in section access.
did you check that the user has access for that particular document folder ?? because as you said you are able to login in the local system but not in access point so check whether the user has access permission for that document folder