Section Access

[tmumaw]

When I am using section access what user name and password do I use for the reload from QMC?

Thanks

[tmumaw]

!s there anything special that needs to be set in the QMC?

[Clever_Anjos]

Not at QMC, please check this configuration into your Document Properties

[tmumaw]

That is set correctly.  In the QMC there is a tab labeled Users.  When you click on that you have an option of 2 User Management and Section Access Management.  Do I need to do anything under section access management?

[Clever_Anjos]

I have a SBE license, I don´t have that tab.

[chetansehgal]

Hi Thom,

You can try omitting the '*' also leave the PROFITCENTER as blank for user ADMTEM in section Access.

By leaving the value blank, the user ADMTEM  will be able to see all the data.

Thanks,

Chetan

[tmumaw]

Good Morning....at least on my end.  I tried something different.

STAR is *;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, %PROFITCENTER

    ADMIN, KENT\QVSVC, *

    ADMIN, KENT\ADMTEM, 130331

    ADMIN, KENT\ADMTEM, 130531

    ADMIN, KENT\ADMTEM, 130631

    ADMIN, KENT\ADMTEM, 130831

    ADMIN, KENT\ADMTEM, 732271 

    USER, KENT\MUMAWT, 732271

    USER, KENT\BRUMBACHJ, 130831

    USER, KENT\BRUMBACHJ, 732271

];

What appears the * is not working.

Thom

[Clever_Anjos]

Very weird indeed. I´ve been using this feature for a long time

[tmumaw]

I used the above and now I don't have access to the model.

//STAR is *;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, %PROFITCENTER

    ADMIN, KENT\QVSVC,

    ADMIN, KENT\admtem, 

    USER,  KENT\BRUMBACJ, 130831

    USER,  KENT\BRUMBACJ, 732271

];

Section Application;

LOAD * INLINE [

    Profit Center, %PROFITCENTER

   130831, 130831

   732231, 732231

];

[tmumaw]

Just found this in the QlikView for Developers Cookbook.

Interesting.....

Lastly, and this is usually a problem for Admin/Manager users who want to see all of the data, if all of the data is not connected to the section access table, the unconnected data will be removed by the reduction process, even for * connected users.  The star is a wildcard that allows the user to be connected to all of the data, but it is not considered for the reduction.

[chetansehgal]

By model you means you cant see tables in data model viewer or you are not able view any data in the dashboard using ADMTEM as login?

Also use all the value like ACCESS,NTNAME  in Upper Case only.

Try using KENT\ADMTEM instead of KENT\admtem,