Object level section access

[santhosh_k_n]

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

[nirav_bhimani]

HI,

Use QVUSER() function in the layout condition of object

E.g.

If(QVUSER()='XYZ',1,0)

Regards,

Nirav Bhimani

[santhosh_k_n]

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

[jagan]

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.

[nirav_bhimani]

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