topic Data Reduction show all data when reload in QlikView

Data Reduction show all data when reload

Sat, 17 Sep 2011 08:02:51 GMT

Hi, i'm using Data Reduction and it works well when open the file, reducting date based on userid, but when press reload button the data reduction dissapear and whole information is available for everyone. Does anyone know how to avoid it?

I have checked the option data reduction based on session access, and this is the script:

Section Access ;

Load * Inline [

USERID, PASSWORD, ACCESS, SUBAREA, AREA

A, A, Admin, *, *

B, B, User, *, AA

C, C, User, AA11,

D, D, User, AA22,

E, E, User, *, BB

F, F, User, BB11,

G, G, User, BB22,

H, H, User, *, CC

I, I, User, CC11,

J, J, User, CC22, ];

Section Application ;

Load * Inline [

SUBAREA, AREA

AA11, AA

AA22, AA

BB11, BB

BB22, BB

CC11, CC

CC22, CC ];

Thanks in advance!

Re: Data Reduction show all data when reload

magavi_framsteg — Sat, 17 Sep 2011 08:47:22 GMT

Hi TheFourth.

The way you describe your problem is the exact way section access is designed to work.

When you reload a doc, it is always reloaded with ALL data
Section access is only applied once you log in
If you, after logging in, reload the doc, the doc will again be reloaded with ALL data
Section access will then be applied after closing the doc and reopening it.

You also have the option to restrict the doc to prevent USER's from reloading docs.

Document Settings > Security

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Data Reduction show all data when reload

Sat, 17 Sep 2011 13:18:29 GMT

Ok, now i see it clearly.

Thanks!