topic Re: section access management use in QlikView

section access management use

Wed, 05 Nov 2014 11:21:53 GMT

hi dears

is "Section Access Management" a substitute for section access coding inside the hidden script of the document? if yes, how i should apply it on a document after setting it up in section access management part of QMC?

regards,

Mana

Re: section access management use

Peter_Cammaert — Wed, 05 Nov 2014 12:09:23 GMT

Once you start setting up Section Access in QMC, the page will supply you with an URL that you need to insert after the FROM clause in your Section Access LOAD statement.

The Section Access section of your document will - upon first reload - obtain SA data from the management service instead of from a file or another source.

Re: section access management use

Peter_Cammaert — Wed, 05 Nov 2014 12:14:08 GMT

You'll need a Publisher license to manage Section Access data in the QMC.

Re: section access management use

Wed, 05 Nov 2014 12:39:01 GMT

thanks for your answer,

it was my section access code befor:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, TAKSARAN\M.AZIZI

ADMIN, TAKSARAN\N.RAFINIA

USER, TAKSARAN\IT

USER, TAKSARAN\NOIT

];

Section Application;

now i made it in section access management and the url is: http://serverbi:4780/QMS/AuthTable

what would be the section access code then ?

Re: section access management use

Wed, 05 Nov 2014 12:47:47 GMT

like this?

Section Access;

LOAD ACCESS,

NTNAME

FROM

[http://serverbi:4780/QMS/AuthTable]

(html, utf8, embedded labels, table is default);

Section Application;

Re: section access management use

Peter_Cammaert — Wed, 05 Nov 2014 14:28:30 GMT

That depends on what table layout you created in Section Access Management. As you have seen, QMC allows you to create any column in the Section Access table, including QlikView columns and custom columns (your own). If you created ACCESS and NTNAME columns, and entered data in them, then your LOAD statement will do just fine.

Re: section access management use

lkartchner — Tue, 16 Dec 2014 00:03:36 GMT

Peter, the example you provided mana looks like exactly what I'm after. If I have multiple section access tables defined in QMC, where you say "table is default" would I change "default" to whatever I named the table in QMC?

Re: section access management use

Peter_Cammaert — Tue, 16 Dec 2014 07:53:41 GMT

Yes indeed.

Re: section access management use

Tue, 23 Dec 2014 13:04:35 GMT

I need to give sheet level access through section access management,

can nybody help in this

thanks

Re: section access management use

Peter_Cammaert — Tue, 23 Dec 2014 13:12:32 GMT

Have a look at the many discussions and documents on this community that deal with sheet level access, like this one:

Sheet level access

or this one:

Section Access - Hide Sheet Level