I understand there are 2 issues here:
1. Access not working on Server.
2. Data Reduction.
For Point 1 there could be a few reasons:
1. User with Different Domain name.
2. Users that are not related to the Domain in the Active Directory.
What I suggest is to use function OSUser() when login with the user who can see all.
Then check if other users are assigned, in the Active Directory of the QV Server, to the specific Domain name.
For point 2:
See Attached File, look for REDUCTION.
thank you very much for your answer.
Probably I didn't explain well that the section access code reads users on section access table wrote on Server also if I execute on local Client, so in Client execution and Server execution it reads the same information.
On Client, every user can see its data, as I want implementing section access.
On Server I have the Publisher, when I execute the .qvw only the ADMIN of development can see data and the other users can't open their dashboard.
If I copy the .qvw file from SourceDocuments to Documents folder to show it in the AccessPoint, users can see data exactly as I want. So I think it depends from settings in Publisher on the Management Console.
Thank so much for any help.
Thank you for your ans. As you mentioned we need to provide User ID of Publisher Service.
What exactly mean that ? Can you provide me some sample code with NT section access ?
In your case what is your User ID of Publisher service ?
How can we get this User Id ; Do we required to do something for that ?
One more question here : Do we require to add User Entries in USER tab of Publisher ?
Christian, Your ans. will surely appreciate to me.
thank you for your answers:
1) Yes the username of the Publisher Service is on the list as first.
2) The informations written in log file are ok, everything is went regularly.
In the community I found this topic: http://community.qlik.com/message/361990#361990
They have the same problem, but without a definitive solution. I tried to use blank but the problem persists.
My Publisher is SR2 11.0.11426.0
If you look at the document that Ori posted you will find the example the below. Notice how the ADMIN is blank for the OMIT field? This means he has rights to see everything. The publisher account will need that to be able to download all the information into the QVW.
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, SALES
USER, USER2, U2, WAREHOUSE
USER, USER3, U3, EMPLOYEES
USER, USER4, U4, SALES
USER, USER4, U4, WAREHOUSE
USER, USER5, U5, *
I write to report that I solved my problem. Unfortunatly it was an error in Section Access logic, because I have a hierarchical control to see dashboard, so a number of table greater than the typical examples and the error was to have the final table, who have access to tables, with the explosion of all possible access out of the
Thank you so much for your help to perfect my code.