topic Re: Section Access Issue in QlikView

Section Access Issue

Karl_Hart — Wed, 15 Oct 2014 14:15:26 GMT

Hi, when I was testing section access it worked on a simple model - this restricted the User hartk to only be able to see "CU RR"

Section Access;

Star is *;

LOAD * INLINE [

ACCESS, SERIAL, NTNAME, SP 12

ADMIN, *, WCHG\QV_User,

USER, *, WCHG\hartk, 'CU RR'

];

SECTION Application;

Table:

LOAD * Inline [

Property, SP 12

1, VOID

2, VOID

3, NEW

4, CU RR

5, CU RR

6, CU RR];

However, when I apply it to my actual data I cant get it to work, no matter what I try I cant get the user hartk to only be able to see data for his manager (ie MRS MANAGER)

Section Access;

Star is *;

LOAD * INLINE [

ACCESS, SERIAL, NTNAME, FIN MANAGER

ADMIN, *, WCHG\QV_User,

USER, *, WCHG\hartk, 'MRS MANAGER'

];

SECTION Application;

Any ideas what I'm doing wrong?

Thanks.

Re: Section Access Issue

fkeuroglian — Wed, 15 Oct 2014 22:33:50 GMT

Hi, do you check the "initial data reduction based in section acces"???

Re: Section Access Issue

Karl_Hart — Thu, 16 Oct 2014 09:47:32 GMT

Thanks Fernando, I hadn't got that selected, it has helped narrow down the issue.

I can now apply restrictions in my main document, but only to data that I load in an inline table, but not to any of my data that I load from the QVD files.

I cant understand why!

Re: Section Access Issue

SunilChauhan — Thu, 16 Oct 2014 09:51:47 GMT

use all in upper in all fields of section access on inline table

Re: Section Access Issue

mr_novice — Thu, 16 Oct 2014 10:32:20 GMT

Did you add yourself as ADMIN?

Had a similar problem where all possible combinations of "SP 12" in table were not present in SA table.

Re: Section Access Issue

Karl_Hart — Thu, 16 Oct 2014 12:04:26 GMT

Thanks for that, it now works if I convert my source data into CAPITALS.

Is there any way around this?

Re: Section Access Issue

fkeuroglian — Thu, 16 Oct 2014 12:07:12 GMT

Perfect Karl, it is a requirement to set CAPITAL leters to the field that you put in the section acces, it is a rule