Section access on sheet level

[#1]

Hi all,

     I've made a test for section access on sheet level("Data Team" can see all sheets, the users in "IB Team" only can see SH10 and SH11).

     But It doesn't work as I expect. I don't know what's wrong in my qvw file.

     Please give me some advice.

Thanks and best reagrds,

Keep going.

[jagan]

Hi,

Check this link

Sheet level access

Sheet Level Access

Regards,

Jagan.

[Bill_Britt · Accepted solution]

Hi,

Section Access would be something like this.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,PROFILE

    admin, college, college,COLLEGE

    user, physics, physics,PHYSICS

    user, chemistry, chemistry,CHEMISTRY

    user, maths, maths,MATHS

];

Section Application;

Profile:

LOAD * INLINE [

    PROFILE, SH01, SH02, SH03, SH04

    PHYSICS, 1, 1, 0, 0

    CHEMISTRY, 1, 0, 0, 1

    MATHS, 1, 0, 1, 0

    COLLEGE, 1, 1, 1, 1

Then your show sheet condition would be like

SH02<>0

[#4]

Thanks too much.

[beck_bakytbek]

Hello Going Keep

I have one question to issue: Access Section

How can i create Excell-Sheet to make visible some Sheets within QlikView?

i saw one exmple and tried to use, but i didnt have success:

Sript looks as follows:

star is *;

SECTION Access;
Directory;
LOAD ACCESS,
NTNAME,
SAUSER
FROM
[Book1 - Kopie.xlsx]
(ooxml, embedded labels, table is Tabelle1);

SECTION Application;

DocSecurity:
LOAD
SAUSER,
TABACCESS.SHEET1,
TABACCESS.SHEET2,
FIELDACCESS.DIVISIONFILTER as Division
FROM
[Book1 - Kopie.xlsx]
(ooxml, embedded labels, table is Tabelle1);

FACTTABEL:
LOAD * INLINE [
Division, Date, Product, ProductSku, Qty, Amt
North, 01/10/2009, Widget 1, ABCD-1234, 52, 220.0097
South, 01/10/2009, Widget 1, ABCD-1234, 52, 220.0097
South, 01/11/2009, Widget 2, EFGH-1234, 10, 120.0000
];

Thanks a lot

Beck

[Bill_Britt]

Hi,

Here is a QVW and Excel Sheet from my example.

Section Access would be something like this.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,PROFILE

    admin, college, college,COLLEGE

    user, physics, physics,PHYSICS

    user, chemistry, chemistry,CHEMISTRY

    user, maths, maths,MATHS

];

Section Application;

Profile:

LOAD * INLINE [

    PROFILE, SH01, SH02, SH03, SH04

    PHYSICS, 1, 1, 0, 0

    CHEMISTRY, 1, 0, 0, 1

    MATHS, 1, 0, 1, 0

    COLLEGE, 1, 1, 1, 1

Then your show sheet condition would be like

SH02<>0

Bill

[beck_bakytbek]

Hello Bill

Thanks a lot for your supporting Feedback

i will try it tommorow and will immediately report you

Thanks a lot

Beck

[#8]

Hello Bill!

I have just one doubt. All of this is to give access and permissions on the document level right?

So, if I have DMS security enabled, when a user, for example 'Admin1' from group 'Executives' opens the document, where is the link between the user that comes from DMS and the user that is stored on the xls?

Do I have to specify it somewhere?

[DBIT]

Really needed to see this. I couldn't visualise it when it was explained to me. Thanks.