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:
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';
UPPER(ACCESS) as ACCESS,
SQL SELECT *
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.