Access Control

[pooja_sn]

I need to implement Aunthorization in qlikview.

Our data contains few Regions and Businesses under each Region. User access should be restricted to limited Region and Businesses.

Eg. User ABC should be able to access LONDON,NEWYORK Region and Retails and Finance Business under these two regions.

I am willing to use OSUSer() as logged in user as our application will be accessed using browser.

How this can be achieved?

[pooja_sn]

Doesn't work.

I still see access to Divisions corresponding to ADMIN only .

I am using a single ACCESS for users now, either ADMIN or USER.

[avinashelite]

if your single entry i.e data for the ADMIN you will get only that ..whats your actual requirement ??

[SunilChauhan]

Can you please try below

admin should have all access

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
ADMIN, domain\UserName,01

ADMIN, domain\UserName,02
USER,domain\UserName,02
];

SECTION APPLICATION;

LOAD * INLINE [
DIVISIONID, description
01, bird-
02, food
];

[pooja_sn]

Yes. This gives me access to Divisions 01 and 02 both.

[paulyeo11]

Hi All 

I have try to play with initial data reduction, I does not see any impact . Can some one share with me how to check ? 

Paul