Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to apply section access such a way, depending on the user log in the number of objects visible to the user must vary.
Let say, I am having 10 charts
if user1 login to the report all 10 charts to be visible
if user2 log in only first 5 reports to be visible
if user3 then last 5 and
if user4 then chart 3,4,7,9,10 should be visible.
Please help me
HI,
Use QVUSER() function in the layout condition of object
E.g.
If(QVUSER()='XYZ',1,0)
Regards,
Nirav Bhimani
Thanks Nirav,
1. This works fine for limited user and limited charts,if users are more are around 20 to 30 then its bit difficult
2. If my section access is NT based will it work
Hi Santosh,
Please find attached file for solution
Script used in the file.
Section Access;
LOAD * INLINE [
ACCESS, USERID
Admin, A
User, B
User, C
USer, D
];
Section Application;
ChartAccessMatrix:
LOAD * INLINE [
USERID, CH01, CH02
A,1,1
B,1,0
C,0,1
D,1,1];
When A user access the Dashboard he can see both CH01 and CH02.
When D user access the Dashboard he can see both CH01 and CH02.
When B user access the Dashboard he can see only CH01.
When c user access the Dashboard he can see only CH02.
Hope this helps you.
Regards,
jagan.
Hi,
If you want to show particular chart to many user and hide to few user then write this condition is reverse way
It will work with NT name as well.
If(Wildmatch(QVUSER(),'XYZ','abc'),0,1)
Regards,
Nirav Bhimani