0 Replies Latest reply: Aug 21, 2017 8:19 AM by Erik Pieterman RSS

    Simple sectionaccess not working

    Erik Pieterman

      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)

       

      ;