Solved: How to control data access? - Qlik Community

Report Inappropriate Content · ‎2011-02-12

Hi All,

I have one scenario:

If I have the following data:

Region Revenue.

Brazil $100

France $200

Then there are two guys:A and B.

If A accesses the data, he only can see the Brazil and B only could see the France, how to control it? I can get their windows account.

Thanks.

Miguel_Angel_Baeyens · ‎2011-02-12

Hello,

A simple section access for what you are looking for would be as follows:

1.- First back your document up just in case something goes wrong

2.- Then create the following script at the beginning or at the end

STAR IS *; SECTION ACCESS; SectionAccess: // For example purposes being read from inline, any other valid source will workLOAD * INLINE [ACCESS, NTNAME, REDUCTIONADMIN, DOMAIN\ADMINISTRATOR, *USER, DOMAIN\A, AUSER, DOMAIN\B, B]; SECTION APPLICATION;ReductionTable:LOAD * INLINE [REDUCTION, REGIONA, BrazilB, France]; Data:LOAD Region, RevenueFROM Source

3.- Go to Settings, Document Properties, Open and check "Select data based on Section Access"

4.- Reload, close QlikView and open QlikView.

5.- If everything went fine, that is, your domain user credentials were passed on to the document, then you will see one of both regions selected. If that's the case, go back to Settings, Document Properties, Open and check instead "Reduce data..." and "Strict Exclusion".

6.- Close QlikView, open the document again and you should see only the records related to the user you are logged on (in my example DOMAIN\A or DOMAIN\B

Hope this helps.

View solution in original post

Report Inappropriate Content · ‎2011-02-12

The feature you're looking for is "Section Access/Reduction" based on NTNAME

There is a very comprehensive guide here:

http://blog.qvapps.com/2010/06/10/introduction-to-qlikview-section-access/?utm_source=feedburner&utm...

Just make sure you make a backup copy of your app without section access as everyone locks themself out at least once

Miguel_Angel_Baeyens · ‎2011-02-12

Hello,

A simple section access for what you are looking for would be as follows:

1.- First back your document up just in case something goes wrong

2.- Then create the following script at the beginning or at the end

STAR IS *; SECTION ACCESS; SectionAccess: // For example purposes being read from inline, any other valid source will workLOAD * INLINE [ACCESS, NTNAME, REDUCTIONADMIN, DOMAIN\ADMINISTRATOR, *USER, DOMAIN\A, AUSER, DOMAIN\B, B]; SECTION APPLICATION;ReductionTable:LOAD * INLINE [REDUCTION, REGIONA, BrazilB, France]; Data:LOAD Region, RevenueFROM Source

3.- Go to Settings, Document Properties, Open and check "Select data based on Section Access"

4.- Reload, close QlikView and open QlikView.

5.- If everything went fine, that is, your domain user credentials were passed on to the document, then you will see one of both regions selected. If that's the case, go back to Settings, Document Properties, Open and check instead "Reduce data..." and "Strict Exclusion".

6.- Close QlikView, open the document again and you should see only the records related to the user you are logged on (in my example DOMAIN\A or DOMAIN\B

Hope this helps.

suniljain · ‎2011-02-13

Suggestion given by Miguel is pefect . you have to implement section access based on Region Data.

chematos · ‎2012-06-01

Hola Miguel,

Puede haber algún problema para restringir el acceso a campos clave?

Estoy teniendo un problema con eso, con los demás campos me funciona todo correctamente.

Gracias, saludos.

Chema