topic Section Acces in QlikView

Section Acces

Thu, 09 Jul 2009 22:58:18 GMT

I am implementing an access restricted by users. At first the code is good, and when I accede to the document with some user with few privileges works perfectly. The problem comes when I accede with a user with total permissions, since it remains without memory and cannot open the picture. I do not deal which is the problem, since the user with total permissions does not do more than what it was making before implementing the safety, see everything, but making it like that there is no way of acceding...

the code:

USERS:
Section Access; LOAD [ACCESS],
[USERID],
[PASSWORD],
DELEGA
FROM \\Sercuman\Sindel\ejemplos.txt (ansi, txt, delimiter is ',', embedded labels, msq);

section application;
star is *;

DELEGA:
LOAD * INLINE [
DELEGA, Delegacion
"ASTUR", "ASTURIAS"
"ASTUR", "CANTABRIA"
"TODAS", *
"GALICIA", "GALICIA"
"EUSKA", "EUSKADI"
"EUSKA", "ARAGON" ];

Thanks!!

Section Acces

stephencredmond — Fri, 10 Jul 2009 00:19:11 GMT

Hi,

Not sure exactly the problem but I suspect it might be a Strict Exclusion issue. In the Document Properties, Opening Tab, just under where you set to Reduce Data based on Section Access, untick the "Strict Exclusion" check box.

That works?

Stephen

Section Acces

Fri, 10 Jul 2009 20:27:24 GMT

No... It is desactivated... I will try to explain better:

If:

USERS:
Section Access; LOAD [ACCESS],
 [USERID],
 [PASSWORD],
 DELEGA
FROM \\Sercuman\Sindel\ejemplos.txt (ansi, txt, delimiter is ',', embedded labels, msq);

section application;
star is *;

DELEGA:
LOAD * INLINE [
DELEGA, Delegacion
"ASTUR", "ASTURIAS"
"ASTUR", "CANTABRIA"<h3>"TODAS", * (This user does not accede because "out of memory")</h3>
"GALICIA", "GALICIA"
"EUSKA", "EUSKADI"
"EUSKA", "ARAGON" ];

else

if:


 USERS:
Section Access; LOAD [ACCESS],
 [USERID],
 [PASSWORD],
 DELEGA
FROM \\Sercuman\Sindel\ejemplos.txt (ansi, txt, delimiter is ',', embedded labels, msq);

section application;

No problems with memory... i don't understand it. theoretically it should be the same select all, or select nothing... not?

PD: Sorry for my english...

Section Acces

stephencredmond — Fri, 10 Jul 2009 20:31:25 GMT

Hi,

Is it possible to see the entries in ejemplos.txt ?

Possible to upload a QVW?

Usually any out of memory errors, excluding that the data of the QVW does exceed your memory, are down to cartesian joins, especially where you include 2 unrelated values in a chart. This can sometimes be hidden by having a smaller data set (which would happen if one of your other users was logged in) and only show up when all the data is loaded.

Stephen

Section Acces

Fri, 10 Jul 2009 20:58:23 GMT

Thanks a lot..

The file ejemplos.txt:


ACCESS, USERID, PASSWORD, DELEGA, DEPAR
ADMIN, ADMIN, PASS1, TODAS, ADMON
USER, USER2, PASS2, TODAS, ADMON
USER, USER3, PASS3, TODAS, DIRCOMPRAS
USER, USER4, PASS4, ASTUR, DELEGA
USER, USER5, PASS5, GALICIA, DELEGA
USER, USER6, PASS6, TODAS, COMPRAS
USER, USER7, PASS7, EUSKA, DIRVENTAS
USER, USER8, PASS8, EUSKA, DIRVENTAS

Section Acces

stephencredmond — Fri, 10 Jul 2009 21:19:46 GMT

Hi,

I have put these users and connections into a QVW with a simple amount of data connected to the Delegacion field and it all works perfectly as I would expect for the different users. I get reductions where they should be and all data for "TODOS" users.

I would look at the data and joins now - look for possible cartesians. One way to do it is to do a copy of the document with no charts at all and reload - see if you still get errors. If not, copy charts from the original copy one at a time until you find an error.

Regards,

Stephen