Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon to everybody,
I work in a chemistry company and I am developing a BI dashboard draft in Qlikview (personal edition).
The idea is that the key account managers (KAM), country managers, regional managers, world account managers and segment managers have the same report but just only their area of interest.
I have in my database several field with "KAM","Country","Region", "customer", "segment" among them.
I want to write a "section access" that grants me the confidentiality of the info. For make it clearer:
KAM: Only can access to their local accounts (the lines in the DB that the field "KAM" has their name on it)
Country managers: Only can access to their countries (the lines in the DB that the field "country" has the countries they manage)
Regional managers: Only can access to their regions (the lines in the DB that the field "region" has the regions they manage)
World account managers: Only can access to their local accounts and their global accounts (the lines in the DB that the field "KAM" has their name on it and the lines that customer has the name of the global account they manage)
Segment managers: Only can access to their segments (the lines in the DB that the field "segment" has the segments they manage)
I connect the Qlikview to a ODBC and I want to store the "access" table in the same server.. is this feasible?
Please, any help will be good received.
Thanks in Advance!
Alex
With a simplier example I will be very grateful too!
Hi alex
just go through example
may it helps you
thanks
rohit
Hi,
Go through the Section Access topic in the Qlikview Reference Manual document, you will find the example and explanation for you requirement.
or just go through this document
http://community.qlik.com/docs/DOC-1853
Hope this helps you.
Regards,
Jagan.
Thanks for the examples! As I have the personal edition, I can not open qvw files . Please could you paste the script code here?
Thanks a lot!!
Thanks Jagan!
I have read the info, but I don't understand how to filter by various fields.
Regards!
Please, I need some help.
I want to reduce the data depending on who access the dashboard.
Thanks I have read them, and I still dont have a solution. Sorry for the insistent, but I like qlikview and this security problem may me go in other decision.
I will reduce the problem
Brand | Segment | Sales |
---|---|---|
A | 1 | 2000 |
A | 2 | 100 |
A | 3 | 12000 |
B | 1 | 3155 |
B | 1 | 4654 |
B | 2 | 321321 |
C | 2 | 544 |
C | 3 | 4897 |
C | 4 | 21321 |
C | 1 | 513463 |
I have 7 users -> 3 Brand manager and 4 segments analysts
They should have access as the following table indicates, where the * means all.
USER | BRAND | SEGMENT |
---|---|---|
ADMIN | * | * |
U1 | A | * |
U2 | B | * |
U3 | C | * |
U4 | * | 1 |
U5 | * | 2 |
U6 | * | 3 |
U7 | * | 4 |
Do you understand my problem? is it feasible?
Hi Alex,
Your script has some syntax errors. Since you are using Personal Edition I cannot attach any applications for you, but use this script instead. Notes to bear in mind:
Data:
LOAD * INLINE [
BRAND, SEGMENT, Sales
A, 1, 2000
A, 2, 100
A, 3, 12000
B, 1, 3155
B, 1, 4654
B, 2, 321321
C, 2, 544
C, 3, 4897
C, 4, 21321
C, 1, 513463
];
SECTION ACCESS;
Security:
LOAD * INLINE [
ACCESS, USERID, BRAND, SEGMENT
ADMIN, ADMIN, A, *
ADMIN, ADMIN, B, *
ADMIN, ADMIN, C, *
ADMIN, ADMIN, *, 1
ADMIN, ADMIN, *, 2
ADMIN, ADMIN, *, 3
ADMIN, ADMIN, *, 4
USER, U1, A, *
USER, U2, B, *
USER, U3, C, *
USER, U4, *, 1
USER, U5, *, 2
USER, U6, *, 3
USER, U7, *, 4
];
SECTION APPLICATION;
Hope that helps.
Miguel