I am severely facing problem with Qlikview Section Access for data reduction.
I am using NTName and Department for data reduction. In Inline statement
LOAD * INLINE [
ACCESS, NTNAME, DEPARTMENT
ADMIN, Domain\Name, *
And in the entire script made Department as uppercase. and checked 'initial data reduction based on section Access' and 'Strict Exclution'.
I have checked without giving Section Access; and Section Application; I am getting correctly.
But I am getting all the above Departments for ADMIN,USER1 and USER2 (ie., everyone is able to see all the departments)
Please help me.
Yes I made the fields of Department as upper case in entire application and tried by uncheck 'Strict Exclusion'.
But facing the same problem getting all departments in ADMIN as well as USERS.
the code seems all fine.
But, how are you checking on the access ;has any other user logged onto the app in the server as a user and not admin and checked for what departments are available.
Here are some links that should help you sort things out:
On the second link, there are further links to other Section Access related blog posts, three of them, so be sure not to miss those as well. I think this should be a good start for you to confirm everything.
One thing I do when I am troubleshooting Section Access and DDR, is comment the Section Access line of the script, leaving the load statements etc., this way you will be able to see the Section Access table in the Data Model Viewer to see how things are linking to ensure you have that part working correctly, and you can then also use some List Boxes to further troubleshoot things as well... Hopefully this helps you move things forward here.
Oh, one other thing, be sure you read up on the meaning of * in the reduction field versus no value, you are going to want to be sure anybody you want to see 'everything' gets a no value, as * only includes values loaded for the other users, so if you have some values that are not associated with any users, those would never appear etc. This something that is commonly missed. The catch though is that any users with no value and strict exclusion enabled, will NOT be able to open the application via QVServer, only Desktop with the Admin Override option set...