section access not reducing data for ad users

hello all,

we are trying to reduce data for users based on operating_unit,

our customers access qlikview application from our product, authentication is done using a web ticket approach and users can now access the qlikview application without a problem. We don't maintain user data and authentication is done using LDAP.

Now, we want to implement data reduction using section access. We don't want to have another prompt for user/password, so i created section access script like this:

SECTION Access;

LOAD * Inline [

ACCESS, NTNAME, USERID, OPERATING_UNIT

USER, DOMAIN\X1, *, 87

USER, DOMAIN\X2, *, 93

];

Section Application;

both the users can access the application and can see the complete data, reduction is not working. if i select strict exclusion, it is prompting for a user/pwd.

Re: section access not reducing data for ad users

Does your data model have 'OPERATING_UNIT' field in some table. Also can anyone other than those two access the application. Does 87 and 93 values exit in your Data-model data? Also I dont think you need USERID.

But there is a small catch here. When you use * the developers would be able to see only 87 and 93, because * only includes everything thats been mentioned in the list. If you have other values like 88,89 then you have to do something like