topic Re: Section Access not reducing in QlikView

Section Access not reducing

b_garside — Tue, 25 Feb 2014 22:05:55 GMT

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.

Re: Section Access not reducing

Tue, 25 Feb 2014 22:16:58 GMT

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

Re: Section Access not reducing

b_garside — Tue, 25 Feb 2014 22:20:10 GMT

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

Re: Section Access not reducing

Tue, 25 Feb 2014 22:29:52 GMT

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?

Re: Section Access not reducing

b_garside — Tue, 25 Feb 2014 22:32:48 GMT

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

Re: Section Access not reducing

b_garside — Tue, 25 Feb 2014 22:35:13 GMT

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

Re: Section Access not reducing

Tue, 25 Feb 2014 22:49:12 GMT

Also try this...

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

Re: Section Access not reducing

Tue, 25 Feb 2014 22:50:07 GMT

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.

Re: Section Access not reducing

Tue, 25 Feb 2014 22:51:54 GMT

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