0 Replies Latest reply: Feb 22, 2017 9:04 AM by Mike E RSS

    Section Access with Qliksence and SQL not working

    Mike E

      Hi Fellow Qlikers,

       

      I'm trying to implement a robust section access NOT using inline code but via SQL. I've already seen Dork's video but doesn't work for me.

       

      What I  have is as follows - note the bridge file contains a compound access key and works a Qlik filter without any security. The accessID  key  joins to the master Fact table and the Access to the Authorisation table via AuthorisationBridge:

       

      AuthorisationBridge:

      LOAD

        AccessID,

        [ACCESSKEY]

      FROM [$(vQVDPath)AuthorisationBridge.qvd](qvd);    

       

      SECTION ACCESS;

      LOAD

           ACCESS,

           USERID,

           ACCESSKEY 

      FROM [$(vQVDPath)Authorisation.qvd](qvd);  

       

      But all I get is locked out and have to open without data to get back in.  I have also tried using SQL directly  i.e.

       

      LIB CONNECT TO '2012 Security';

      LOAD

           UPPER(ACCESS) as ACCESS,

           USERID,

           ACCESSKEY; 

      SQL SELECT  *     

      FROM [2012_Security].[dbo].[QlikSectionAccess];

       

      But no access even  tried loading  this with my Dimensions then using a resident load to reload under section access. With a few million rows on the bridge table  using an inline table is just NOT an option here.

       

      Any help would be  very much appreciated.

       

      Thanks & Kind Regards

      Mike