Section Access not reducing

[b_garside]

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.

[#2]

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

[b_garside]

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

[#4]

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?

[b_garside]

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

[b_garside]

I thought NTNAME and the reduction field is all I really need? 

[#7]

Also try this...

Go to Document Properties in settings tab.... go to sub tab "Opening" and select "Strict Exclusion"

[#8]

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.

[#9 · Accepted solution]

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