section access

[#1]

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

[giakoum]

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

It should be null

[buzzy996]

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
];

[#4]

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

];

[#5]

Thanks Ioannis and Carlo.

Ioannis,

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

[buzzy996]

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];

[giakoum]

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

[#8]

Thanks.
It works (:

[giakoum]

Please close this discussion