Section Access through Database

[victor5995]

Hi Folks,

I have requirement to implement section access through database user table that contain USERID. I have to set up this in a way that all the user within this table should able to access the application.

Appreciate any help.....

Thanks

[Peter_Cammaert]

Usually by adding a Link field to your section access table that connects to your data. Imagine that you want to reduce on Region, and your region field is called ... er Region, then add a column to your database table wherein you specify the allowed region for each user. Load the column together with the userID and you will be set.

If you want to be able to specify multiple regions per user, add a link table to Section Application wherin you expand each LINK value (e.g. NS for North+South, or SEW for South+East+West) into multiple records, each with a different applicable region.

A few very helpful community resources (by Henric of course):

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/09/methods-for-data-reduction

Best,

Peter

[victor5995]

Hi,

Can some one give me the sample script that I can see how I can use the reduction field with the section access. Below is the sample code that right now I am using.

Section Access;
SA_Table:
LOAD * INLINE[
USERID,ACCESS
ADMIN,ADMIN
SVC1,ADMIN
];

SA_Table:
SQL SELECT

USERID,

'USER' AS ACCESS

FROM TableName;

Section Application;

star is *;

Thanks

[jagan]

Hi,

Check this sample script for REDUCTION

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, REDUCTION

    ADMIN, Admin, password, *

    USER, Sales, password1, 1

    USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

   REDUCTION, Dept,

    1, Sales

    2, Marketing];

Sales:

LOAD * INLINE [

   Dept, Sales

   Sales, 100

   Sales, 200

   Sales, 4646

   Sales, 755

   Sales, 422

   Sales, 42

   Marketing, 2

   Marketing, 453

   Marketing, 54

   Marketing, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as Sales then you can see only Sales data and when you login as Market you can see only Marketing data.

Hope this helps you.

Regards,

Jagan.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Please close this thread if you got the answer, it helps others in finding answers easily.

Regards,

Jagan.

[Anonymous]

What is the meaning of,

star is *;

regards,

[jagan]

* is wildcard character.

Regards,

Jagan.

[victor5995]

Hi Jagan,

As I am new to qlikview, When you said close the threat exactly what you want me to do ?

Thanks,

VIpul

[SunilChauhan]

mark it as helpful or correct among above reply if you found suitable reply

[jagan]

Hi,

Just click on the Helpful and Correct Answer buttons to the posts which helps you most in finding the solution.

Regards,

Jagan.