Hi there i am bussing setting up Qlikview in our business. I would like to know how to use active directory, for username and password.i am not to sure how to put it in the security script. any help in the right direction will be appreciated. this is currently how i have it setup but would prefer to use active directory passwords.
access; load * inline [UserID,DEPT,Access,Password,NTNAME kallie IT Admin 123 test\kallier hilt IT Admin 321 test\hiltg jack IT Admin 456 test\jackj sam Sales User 654 test\samv andy Production Admin 654 test\andyd ] ;
sectionapplication; staris *;
load * inline [DEPT,Salesperson IT,* SALES,sales Production, production ] ;
any help in the right direction will be appreciated
Check this post that has working code. Base your on it to get it working. Your script seems to be fine, except for the names and values of fields that must be all UPPERCASE in Section access table. You can set the section access ... section application at the beginning or at the end of the script. Note that QlikView is case sensitive for both names and values in fields, so field "SALES" is not the same as field "sales".
That is correct, it will take the password from the current credentials. If you don't need to perform batch reloads as in the example discussed in the post I mentioned, you don't even need to specify USERID and PASSWORD at all. You can remove them if you are not going to use it.
It was confusing me a lot. I just have one other question which I am not sure how to specify. In the section application how do I specify that a certain salesperson can only see their data. We have 10 salespeople but only the salesmanager is allowed to see all 10 people sales data but each salesperson should see his own sales?
Zone is a field that must exist in your data model. The piece of code above is just an example. Think of sales people and a sales manager, and customers instead of zones. Each sales people can see his or her customer, but the sales manager can see all customers, so he needs to have all three lines for the three customers.