topic Re: Data reduction in QlikView

Data reduction

sampada0810 — Wed, 25 Nov 2020 16:16:04 GMT

I am implementing security in m application.

I want to restrict data for certain users.

how can I achieve this?

i have written my script as follows:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, GEOGRAPHY

A, A, A, ALL,

U1, U1, U1, "Abc"

U2, U2, U2, "Xyz"

U3, U3, U3, ALL

];

Section Application;

I want to restrict the field GEOGRAPHY, i.e foe U1 only "Abc" data should be visible

and for U2 only "Xyz" data should be visible.

I have also checked Initial Data reduction based on section access.

I am unable to login with this script in place.

what shall I do???

Re: Data reduction

sushil353 — Tue, 04 Oct 2016 09:22:58 GMT

Hi,

Check this out: https://community.qlik.com/docs/DOC-5917

HTH

Sushil

Re: Data reduction

jonathandienst — Tue, 04 Oct 2016 09:30:40 GMT

If Abc and Xyz are the only possible values of Geography, then this should work:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, GEOGRAPHY

ADMIN, A, A, *

USER, U1, U1, Abc

USER, U2, U2, Xyz

USER, U3, U3, *

];

Section Application;

The * references only the values listed elsewhere in the Section Access table load. Make sure that you have a field in the main model called GEOGRAPHY (case is significant), and that at least some of the values under GEOGRAPHY in the section access table exist in the main model GEOGRAPHY field.

Re: Data reduction

sampada0810 — Tue, 04 Oct 2016 09:41:31 GMT

I did the same, still getting error.

Access denied!

Actually I have many other values also in my GEOGRAPHY Column.

But I want to restrict at least for 2.

Re: Data reduction

rajpreeths — Tue, 04 Oct 2016 10:35:51 GMT

Hello Sampada,

I have tried with the sample data . Section access is working fine for me. Below is the script I created .

Section Access;

LOAD * INLINE [

ACCESS, USERID, GEOGRAPHY

ADMIN, ADMIN /* For all possible values leave this column data as emptied one (no letters) */

USER, user1, ABC

USER, user2, XYZ

];

Section Application;

/** LOAD the REDUCTION field in uppercase in the SEction Application part */

/** In this casse reduction field is GEOGRAPHY **/

LOAD * INLINE [

GEOGRAPHY

XYZ

ABC

];

Note :

1-> If you are fetching reduction field data from source or excel or text files then the field name and values to be restricted to the users should be in upper case (use upper function).If values are not in upper case then section access will not be working fine.

2-> For inline load , section access will be working fine even if we don't have the values in upper case. In the above case reduction field ( GEOGRAPHY) has been loaded using Inline load.If you fetch this field from external file then definitely the field should be loaded with UPPER function - upper(GEOGRAPHY) as GEOGRAPHY in section application part .

3-> Ensure to check the below option under Settings->Document Properties -> Opening

PFA the attachment for further reference.

U can just open the document by simply giving username alone.

ADMIN for ADMIN

USER1 for ABC data

USER2 for XYZ data

Please feel free to ask if you have any queries.

Thanks,

Rajpreeth S

Re: Data reduction

fvelascog72 — Tue, 04 Oct 2016 10:43:50 GMT

Hi,

You can try with this:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, GEOGRAPHY

ADMIN, A, A, *

USER, U1, U1, "ABC"

USER, U2, U2, "XYZ"

USER, U3, U3, *

];

Tabla:

LOAD * Inline [

GEOGRAPHY

ABC

XYZ

RST

UVW

];

Section Application;

Tabla:

LOAD * Inline [

GEOGRAPHY

ABC

XYZ

RST

UVW

];

You must have inside Section Access all values of the field GEOGRAPHY in Uppercase.

Cheers.

Re: Data reduction

Anonymous — Tue, 04 Oct 2016 11:37:28 GMT

Is interesting vc have an excel to access restrictions.
in its action session.

LOAD * INLINE [
    ACCESS, USERID, PASSWORD, PK_ACESS
    ADMIN, A, A, *
    USER, U1, U1, 1
    USER, U2, U2, 2
    USER, U3, U3 *
];

IN EXCEL FILE CREATE TWO COLUMNS (PK_ACESS AND GEOGRAPHY).

Recalling that the geography field is key sensitive, with the information from your QVD

Re: Data reduction

Peter_Cammaert — Tue, 04 Oct 2016 11:57:59 GMT

Indeed, all values in Link Fields including the names of the fields themselves should be in UPPER CASE. Otherwise, there will not be a single value that links to the data model, and your document will reduce to nothing for all USERIDs. If "Strict Exclusion" has been enabled, you will effectively shut everybody out...

Re: Data reduction

punitpopli — Wed, 05 Oct 2016 08:54:00 GMT

Hi Sampada,

For section access the column on which you are reducing must be in CAPS and same values should be mapped in section access script

for eg : IN SECTION ACCESS script

GEOGRAPHY

ABC

XYZ

and for ALL you can keep it blank

IN Data if the values of geography column in in lower case then change it to :

UPPER (geography ) as GEOGRAPHY

Hope this will help!