topic User Access in QlikView

User Access

pkelly — Mon, 31 Aug 2009 21:22:03 GMT

Hi....

We have product managers who look after product groups.

e.g. manager "A" looks after "Sawn" whilst manager "B" looks after "Panels".

We do not want manager "A" to see manager "B" and vice versa but do want the sales director to see both.

Mainly due to time constraints at the time - we just created three seperate Sales reports...

I would now like to create one report which interogates the users nt login code to determine what information they can see...

From the research I have carried out so far I know the following...

1) The following command gets me the nt users login code...

Mid(OSUser(),12)

2) I need to create an inline table with the respective codes and level.

ActivityBanding:

LOAD * INLINE [LOGIN, LEVEL

jbloggs, Sawn

wsmith, Panels

pkelly, All];

It is the next bit I am struggling with...

I have a simple pivot with...

Product Sales

Sawn 1000

Panels 2000

How do I restrict the data being shown.

I thought about an @IF level = panels, show panels but I have a dozen or so products...

Any guidance greatly appreciated...[:)]

User Access

Mon, 31 Aug 2009 21:24:39 GMT

Your inline table should do your restriction for you. But make sure you have section access enabled in your qlickview document.

Go to Settings ->Document settings - > Check "initual reduction based on section access"

User Access

pkelly — Mon, 31 Aug 2009 21:43:57 GMT

Hi Anthony

I tried adding the inline table with no success.

Is it possible that you could post an example?

Paul

User Access

pkelly — Mon, 31 Aug 2009 22:12:04 GMT

Apologies Anthony - found what you mean....Think this will solve my problem

User Access

Mon, 31 Aug 2009 22:15:43 GMT

I sure can, but to be honest with you I have more success using an excel sheet instead of inline for my data. [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3531.Section-example.xls:550:0]

section access;

access:

LOAD

upper(NTNAME) as NTNAME,

[ACCESS],

[GROUP],

upper([CUSTOMER NUMBER]) as [CUSTOMER NUMBER]

FROM;

section application;

LOAD distinct

upper([Customer number]) as [CUSTOMER NUMBER]

FROM (qvd);

Then the document does section limitation based off customer number of the person who is logged in.