Hi all,
I am using qliksense in GCP platform and am trying to perform section access for a global report. I have developer access and the connection that I use is OATH. The person's ID with which the connection created also has ADMIN level access and is included in the section access file.
We have created a Big Query table with the section access excel file. Made sure everything in file is CAPS. Ex:
| USERID |
USER_NAME |
ACCESS |
COUNTRY |
USER_ACTIVE |
DASHBOARD_NAME |
| ABCD\12345454 |
ABCDEF |
ADMIN |
* |
Y |
XYZ |
| ABCD\09799000 |
SSIII |
ADMIN |
* |
Y |
XYZ |
| ABCD\45643576 |
JKJVKJ |
USER |
IN |
Y |
XYZ |
| ABCD\34533454 |
SSSOL |
USER |
SG |
Y |
XYZ |
| INTERNAL\SA_SCHEDULER |
|
ADMIN |
* |
Y |
XYZ |
LIB CONNECT TO 'Google_BigQuery_*******;
SECTION ACCESS;
LOAD USERID,
USER_NAME,
ACCESS,
COUNTRY,
USER_ACTIVE,
DASHBOARD_NAME;
[abcde]:
SQL SELECT `USERID`,
`USER_NAME`,
`ACCESS`,
COUNTRY,
`USER_ACTIVE`,
`DASHBOARD_NAME`
FROM `test`.`abc_test`
where USER_ACTIVE='Y' and DASHBOARD_NAME='xyz';
SECTION Application;
ERROR MESSAGE:
Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.
Data has not been loaded. Please correct the error and try loading again.
Please help!
