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
