Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
in section access for user
instead of giving all programs can I make it star ?
ACCESS | USERID | PROGRAM | PMT |
ADMIN | RGEETHAL | STAR | STAR |
USER | RMURUG19 | B479_CE1_A_Line | PMT1 - Body Exterior |
USER | RMURUG19 | B479_CE1_2017MY | PMT1 - Body Exterior |
USER | RMURUG19 | B479_CE1_A_Line_T | PMT1 - Body Exterior |
INSTEAD OF GIVING LISKE THIS
I
is this possible?
ACCESS | USERID | PROGRAM | PMT |
ADMIN | RGEETHAL | STAR | STAR |
USER | RMURUG19 | STAR | PMT1 - Body Exterior |
Is there any chance to share the qvw with credentials.
can you pls share your gmail
I will share all the details
Thakns
I am not more expert.
Is there any problem to share on community. If yes, Please connect to my user and then send me one message so that i will send you the my Email ID,,
yes
in my local pc I don't have qlikview
so I am unable to share the application
Hi,
try below
LOAD * INLINE [
ACCESS,USERID,PRODUCT,REGION
ADMIN,ADMIN,,
ADMIN,USER1,,EAST
];
Regards
Use * if you want the user to have access to everything you have defined in the section access table.
Use '' if you want the user (or admin) to have access to everything defined in the sections access table, and in addition any other value that might be added in this field.
I'm not sure I understand what you want to restrict here. If the User should see everything, isn't that the same access level as the Admin?
PRODUCT | REGION | |||||||||
VPC | EAST | |||||||||
VPC | WEST | |||||||||
VPC | SOUTH | |||||||||
VPC | NORTH | |||||||||
VPCV | EAST | |||||||||
VPCV | WEST | |||||||||
VPCV | SOUTH | |||||||||
VPCV | NORTH | |||||||||
VMC | EAST | |||||||||
VMC | WEST | |||||||||
VMC | SOUTH | |||||||||
|
Thanks for Reply
for admin I have all access all product and all regions
but as user I want see all products for east region
so I put star in product for user and I put east in region
but its not working for me
when I put star its showing all the data
Then I think you should include Region instead of Program in the Section Access table. Like this:
Load * Inline [
USERID, ACCESS, REGION
ADMIN, ADMIN, ''
USER, USER, EAST
];
(2 single quotes after the ADMIN, ADMIN).
Provided that your connections are right, the User should see all the products but only those associated with Region East. Hope this works.