Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
pieterman
Partner - Contributor
Partner - Contributor

Simple sectionaccess not working

HI

I want to implement section access on a QS server environment (for row and columnlevel access for users)

Alas even the simplest version of this doesnot seem to work (see script below I myself as a user. But when I open the sheet I can see A and B (in the rows) and OM1 (as a column).

What I am doing wrong. Can you please advice me?

Erik

section access;

 

LOAD * inline [

 

ACCESS,USERID,KPI,OMIT

 

USER,xxx\xx,B,OM1

 

USER,INTERNAL\SA_SCHEDULER,*,

 

];

 

 

section application;

 

Load

 

if(log_TableName='edm.dbo.dim_kpi','A','B') as KPI,

 

Log_Duration as OM1,

 

*

 

From [lib://$(vLib)/QVDmeta_log.qvd] (qvd)

 

;

 

0 Replies