topic Re: Re: Access Section in QlikView

Access Section

beck_bakytbek — Tue, 28 Oct 2014 19:36:23 GMT

Hi Colleagues

I have one question to issue: Access Section

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

i saw one example 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/2010, Widget 1, BBCD-1234, 52, 220.0097
South, 01/10/2010, Widget 1, BBCD-1234, 52, 220.0097
South, 01/11/2010, Widget 2, FFGH-1234, 10, 120.0000
];

Do any of you happen to have an idea?

Thanks a lot

Re: Access Section

maxgro — Tue, 28 Oct 2014 19:43:22 GMT

see here or post your qlik doc

Sheets Security with Section Access File

Re: Re: Access Section

beck_bakytbek — Tue, 28 Oct 2014 20:06:03 GMT

Massimo Thanks a lot for your Feedback

Here my Qlikdoc. My Issue is: how can i do in Excell-Sheet a reduction to make visible the sheet within QlikView.

Thanks a lot

Beck

Re: Access Section

maxgro — Tue, 28 Oct 2014 20:10:42 GMT

we can't access your doc; section access?

Re: Access Section

beck_bakytbek — Tue, 28 Oct 2014 20:15:22 GMT

Massimo

Thanks, i used Qlik-License

My Issue is: How can i via Excel make visible some sheets within QlikView?

Thanks

Beck

Re: Re: Access Section

maxgro — Tue, 28 Oct 2014 20:48:06 GMT

I can't open your qlik doc with section access

Only you can

Dwnl attachment

open, configure excel (your user) and save

open 0secacc.qvw

check Initial data reduction in menù, settings, document properties, opening

uncheck strict exclusion in menù.... (you'll check after some test)

reload, save and close qlik doc

reopen: depending on what you set in excel you have 1/2 sheets

Re: Re: Access Section

beck_bakytbek — Tue, 28 Oct 2014 21:14:37 GMT

Massimo Thanks a lot

i will try to do it. if i have still any problem i will report you.

Do you have any examples to this issue? because i can create the reduction within QlikView with Access Inline, but with issue : QlikView via Excell i dont have enough experience.

Thanks a lot any way

Beck

Re: Access Section

beck_bakytbek — Wed, 10 Dec 2014 12:38:48 GMT

Hallo Massimo,

Thanks a lot for your Feedback,

I have a question, regarding access section i used the NTNAME to make some sheets visible and some not( i used my ID as NTNAME). its working, but if i open my file, i can see all sheets, and if i create listbox and selekt my ID, then i see the reduction., how can i make, so if i open my file. i see my fieldsreduction without creating of listbox and selekting my ID.

Thanks a lot in advance

Beck

Re: Access Section

Peter_Cammaert — Wed, 10 Dec 2014 14:24:04 GMT

For all Section Access entries with role = ADMIN, QlikView Desktop will do that. You will get access to everything automatically, every time. This a special feature for developers, and it only works in QlikView Desktop. For other entries with Role=USER opening your document in QV Desktop, or for everybody (even Administrators) opening your document in the AccessPoint, reduction will operate as programmed.

Note that in order to completely close down your document so that people without anything left after data reduction will be thrown out, enable Strict Exclusion in Settings->Document Properties->Opening.

Best,

Peter

Re: Access Section

beck_bakytbek — Wed, 10 Dec 2014 15:00:37 GMT

Hello Peter

First of all thank for your supporting advice,

i tried to do this, and its working: if i (as Admin ) open my file, so i can see my sheets, but my colleagues (as User), they do not have access, they are not able open my file: access denied.

i enabled: strick exlusion, initial data reduction based on section access and prohibit binary load.

what did i wring?

do you have any idea?

thanks

Beck

Re: Access Section

Peter_Cammaert — Wed, 10 Dec 2014 15:24:42 GMT

Either they do not feature in your SA table (specify full domainname\accountname entries) or their data reduction results in nothing. If QlikView has no data left after data reduction, a user will be denied access.

Re: Access Section

beck_bakytbek — Wed, 10 Dec 2014 15:30:02 GMT

Hi Peter,

this is my scripting:

Section

Access;
Directory;
LOAD ACCESS,
NTNAME,
SAUSER,
SHEET1,
SHEET2,
SHEET3,
SHEET4
FROM
[Access Section NTNAME.xlsx]
(ooxml, embedded labels, table is Tabelle1);

SECTION Application;

Directory;
LOAD ACCESS,
NTNAME,
SAUSER,
SHEET1,
SHEET2,
SHEET3,
SHEET4
FROM
[Access Section NTNAME.xlsx]
(ooxml, embedded labels, table is Tabelle1);

What do you mean with; "If QlikView has no data left after data reduction", my issue is, that just some sheet are available for my colleagues.

what did i wrong? if you want, i can send my file

Thanks a lot

Beck