Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The attached QVW is suppose to reduce based on ROLE to Hide some sheets.
Based on the script, what may I be doing wrong? I apologize for not being able to reload this.
Perhaps there is enough to tell what is wrong.
This is your data?
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, ROLE
USER, WBBINC.COM\BGARSIDE, OPERATIONS
];
In this case try with domain WBBINC only.
Regards
Hi Brian
It's hard to guess without source data, but are values in ROLE column on RoleAccess spreadsheet in uppercase?
BTW, if this is not going to be only a test check "prohibit binary load" in Document Properties => Opening.
Lukasz
Yeah its all upper case. Plus I use Upper(). Perhpas I need to remove Access since ROLE is taking place of that field?
ACCESS | NTNAME | USER | ROLE |
USER | MYDOMAIN\BGARSIDE | BGARSIDE | OPERATIONS |
You're using UPPER() in Security table - what about SHEET_ACCESS table? If one of them in uppercase and other one lowercase they won't join to each other.
"ACCESS" is not a problem here. According to your example user BGARSIDE should be able to see all rows in SHEET_ACCESS which have OPERATIONS role assigned.
What's USER column? Does this supposed to be USERID?
Yep all uppercase. maybe it is USER > USERID. I was lost on that one.
I even tried a manual inline and it wasn't working.
ROLE | DASHBOARD | MARKETS | ACTIVEPIPE | ACTIVEOPP | PROPFORECAST | WINRATES | BOOKINGS | MARKETPOS | EXCEL | REPORT | FORM | TRENDS | BDSALES | PLANNING | ADMIN |
ADMIN | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
EXECUTIVE | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
BD | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
OPERATIONS | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
I thought NTNAME and the reduction field is all I really need?
Also try this...
Go to Document Properties in settings tab.... go to sub tab "Opening" and select "Strict Exclusion"
Hi Brian,
I tested your application with an excel created by me and the reduction work correctly.
I think that this can be for the data introduced at section access. Can you give me your domine/user to set this as data and post my test for you?
Regards.
This is your data?
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, ROLE
USER, WBBINC.COM\BGARSIDE, OPERATIONS
];
In this case try with domain WBBINC only.
Regards