Section Access

[#1]

Hi,

i am new to Qlikview and trying to implement section access, i want to restrict data by Division(Field DIV) in my document. i have created NT section access, looks like its working but i noticed some data missing when i open the document from Access point. i was able to see that data if i open the document in personal edition. can someone please let me know if i'm doing something wrong in here.

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME , DIV

    ADMIN, PANTHER\HARISHB, NE

    ADMIN, PANTHER\HARISHB, SE

    ADMIN, PANTHER\HARISHB, W

    ADMIN, PANTHER\BENHAN, NE

    ADMIN, PANTHER\JOEMAN, NE

    ADMIN, PANTHER\QLIK00.SERVICE, *

    USER, PANTHER\JIMMYK, NE

];

Section Application;

SalesmanDimension:

LOAD

      DIV

FROM

$(vPath)SalesmanDimension.qvd

(qvd);

Below is the actual table that has DIV field.

SalesmanDimension:

LOAD

    ACCT_NO AS SalesCode,

    FIRST,

     LAST,

     Name,

     MI,

     DIV,

     Email,

     REGION_MGR,

     UserName,

     ACCT_NO & ' - ' & Name AS SalesName

FROM

$(vPath)SalesmanDimension.qvd

(qvd);

[awhitfield]

Yes, the service account needs to have access to all divisions else they won't load.

Andy

[#3]

Yes i was able to see only NE,SE and W when i log in as HARISHB, the only problem is i'm missing data for Rev Budget in Ground vs Budget chart

[Anonymous · Accepted solution]

Same Situation happened to me as well. In your Division field from your data model has data like ( East , West , North , South) and in your AUTH sheet or Inline table you have enabled only 3 divisions for the users or Admins like (East, West, North).. Even though you mention * for some of the users you will still miss the data for the South after saving the qlikview document.

Example of above scenario,

LOAD * INLINE [

    ACCESS, NTNAME , DIV

    ADMIN, PANTHER\HARISHB, East

    ADMIN, PANTHER\HARISHB, West

    ADMIN, PANTHER\HARISHB, North

    ADMIN, PANTHER\BENHAN, East

    ADMIN, PANTHER\JOEMAN, North

    ADMIN, PANTHER\QLIK00.SERVICE, *

    USER, PANTHER\JIMMYK, West

];

Division:

LOAD * INLINE [

DIV

East,

West,

North,

South

];

--------- in this above scenario you will still miss South Division data for the ADMIN QLIK00.SERVICE even though he has *

This is normal behavoiour of qlikview.. And to over come this issue for ADMIN QLIK00.SERVICE for division give blank space. then that user can see all the data.And make sure strict exclusion is removed when setting up field level or row level security.

Let me know if this helps or i can provide an example with the script

[#5]

Hi Vinay,

Thanks for the reply! if you see the attachments, the fist one is taken from the Accesspoint and the second one from desktop version.  the desktop one is showing all the data but the accesspoint is missing just for one chart "GroundActual Vs Budget" and the fields are Rev Budget and GP$ Budget. it did the same even i load the data making

QLIK00.SERVICE as blank. i have added all the possible values to the QLIK00.SERVICE account and HARISB still no luck.

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME , DIV

    ADMIN, PANTHER\HARISHB, NE

    ADMIN, PANTHER\HARISHB, SE

    ADMIN, PANTHER\HARISHB, W

    ADMIN, PANTHER\HARISHB, C

    ADMIN, PANTHER\HARISHB, CS

    ADMIN, PANTHER\HARISHB, ES

    ADMIN, PANTHER\HARISHB, M

    ADMIN, PANTHER\BENHAN, NE

    ADMIN, PANTHER\JOEMAN, NE

    ADMIN, PANTHER\QLIK00.SERVICE, NE

  ADMIN, PANTHER\QLIK00.SERVICE, SE

  ADMIN, PANTHER\QLIK00.SERVICE, W

  ADMIN, PANTHER\QLIK00.SERVICE, C

  ADMIN, PANTHER\QLIK00.SERVICE, CS

  ADMIN, PANTHER\QLIK00.SERVICE, ES

  ADMIN, PANTHER\QLIK00.SERVICE, M

    USER, PANTHER\JIMMYK, NE

    USER, PANTHER\JESSEB, SE

    USER, PANTHER\MIKEL, C

];

Section Application;

SalesmanDimension:

LOAD

DIV

FROM

$(vPath)SalesmanDimension.qvd

(qvd);

[Anonymous]

That is strange, Did you set up any expression or object level security.

[Anonymous]

Quick question does HarrisB needs access to all the data. if that is the case we have to put him blank as well.

[#8]

No, i don't have any expression or object level security! i have added all the possible values to QLIK00.SERVICE and HARISHB.

[Anonymous]

when you have added does it help Harry.

[#10]

Unfortunately it didn't! i think i'm missing some logic here. below is the actual data model where section access table is linking to salesman dimension.

[Anonymous]

in this log hanging table with only Division in it. Does it have all the data or is it missing anything