topic Re: section access in QlikView

section access

Mon, 04 May 2015 11:09:48 GMT

Hi,
I have a problem with section application.
I have 2 filters:

In the section access:

Filter the "Pub_Company" (each ntname get permissions to different Pub_Company name)

In the section application:

Filter by tabs.(each ntname get permissions to different tabs in the document)

The Pub Company filter dosn't work:

If i filter "pub_company" for one ntname, all the other ntnames can't see the "pub_company" too.

Do you know what is the problem?

SCRIPT:

section Access;

LOAD UPPER(ACCESS) AS ACCESS,

UPPER(NTNAME) AS NTNAME,

PUBCOMPANY as [Pub_Company]

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

LOAD UPPER(NTNAME) AS NTNAME,

UPPER(SH01) AS SH01,

UPPER(SH02) AS SH02,

UPPER(SH03) AS SH03,

UPPER(SH04) AS SH04,

UPPER(SH05) AS SH05

FROM

(ooxml, embedded labels, table is Sheet1);

dim_publishers:

LOAD * Inline [publisher_id,Pub_Company]

1,ARG

2,SPA

3,DSP

4,DDS

];

sheet1:

ACCESS	NTNAME	PUBCOMPANY	SH01	SH02	SH03	SH04	SH05
USER	CYDOORCOM\a	ARG	1	1	0	0	0
USER	CYDOORCOM\c	SPA	1	0	0	1	1
USER	CYDOORCOM\c	DSP	1	0	0	0	1
USER	CYDOORCOM\d	DSP	1	1	1	0	1

Re: section access

giakoum — Mon, 04 May 2015 13:41:48 GMT

what are you using for the other users? star or null?

It should be null

Re: section access

buzzy996 — Mon, 04 May 2015 14:08:21 GMT

can u try some thing like this,

Section Access;
Load * Inline
[ACCESS,USERID,PASSWORD
ADMIN,A,X
USER,U1,Y1
USER,U2,Y2
USER,U3,Y3
USER,U4,Y4
USER,U5,Y5];

Section Application;
Load * Inline [
USERID,Main,Sheet1,Sheet2
A,1,1,1
U1,0,1,1
U2,0,1,0
U3,0,0,1
U4,1,1,1
U5,1,1,0
];

Re: section access

Mon, 04 May 2015 14:31:57 GMT

Section access fields must be in upper case in all statements, try this:

section Access;

LOAD UPPER(ACCESS) AS ACCESS,

UPPER(NTNAME) AS NTNAME,

PUBCOMPANY

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

LOAD UPPER(NTNAME) AS NTNAME,

UPPER(SH01) AS SH01,

UPPER(SH02) AS SH02,

UPPER(SH03) AS SH03,

UPPER(SH04) AS SH04,

UPPER(SH05) AS SH05

FROM

(ooxml, embedded labels, table is Sheet1);

dim_publishers:

LOAD * Inline [publisher_id,PUBCOMPANY

1,ARG

2,SPA

3,DSP

4,DDS

];

Re: section access

Mon, 04 May 2015 16:04:17 GMT

Thanks Ioannis and Carlo.

Ioannis,

I want the other users will see everything!
so why should i use NULL and not * ?

Re: section access

buzzy996 — Mon, 04 May 2015 16:18:53 GMT

i think this is replica of the other post,any how..

use this,

for access,publisher_id as user name and PASSWORD as password

for example here username as 1 and password as y1

Section Access;

Load * Inline

[ACCESS,publisher_id,PASSWORD

USER,1,Y1

USER,2,Y2

USER,3,Y3

USER,4,Y4];

Re: section access

giakoum — Tue, 05 May 2015 09:47:11 GMT

Star means that they will see whatever is mentioned in the section access, that means only the listed PuBCompany. Null means that they can see everything.

See attached document on how section access works

Re: section access

Tue, 05 May 2015 13:11:28 GMT

Thanks.
It works (:

Re: section access

giakoum — Tue, 05 May 2015 14:33:25 GMT

Please close this discussion