This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a Problem with the Security hierachy. I hope you can help me. I have a table with the users
I have a fact table:
Of which I am applying a Section Access to reduce the data:
If I logging with NO_EMPLOYEE = 1 ( Manager). Just show me employees 2 and 3. But omits the sale of employee 1
My requirement is to get 7,500 users Oracle database and give them access by NTNAME. Without using userid and password
I have a qvw example attached . I hope you can help me friends.
Thank you Adam,
I Solved my problem. The attachment content is the solution.
View solution in original post
Do you also wan the subordinates to see their own data as well?
If so then can you not just do this?
NTNAME, // ADD YOUR USER OF WINDOWS.
ACCESS, NTNAME, NO_EMPLOYEE, BOSS, JOB
ADMIN, DOMAIN\A00, 0, , DIRECTOR A
USER, DOMAIN\A01, 1, 0, MANAGER A
USER, DOMAIN\A02, 2, 1, ANALYST
USER, DOMAIN\A03, 3, 1, DEVELOPER
USER, DOMAIN\A04, 4, 5, TESTER
USER, DATA IQ, 5, 6, MANGER B
ADMIN, DOMAIN\A06, 6, , DIRECTOR B
LOAD ACCESS, NTNAME, NO_EMPLOYEE, NO_EMPLOYEE AS BOSS, JOB
Otherwise just exclude employees who don't appear in the BOSS column