topic problem with section access in QlikView

problem with section access

fredericvillemi — Fri, 12 Aug 2011 12:18:49 GMT

Hi,

i have difficulties to understand section access.

I want to have three profiles.

One for admin

One for a user who can see everything

One for a user with a specific dimension filtered.

I'm using this section access :

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, COUNTRY

admin,admin,admin,

USER,super,super,

USER,test,test,France

];

SECTION Application;

OLEDB CONNECT32 TO {removed}

SQL SELECT ATTRIBUTE1,

COUNTRY,

DESCRIPTION from mytable;

SQL SELECT ATTRIBUTE2,

COUNTRY,

DESCRIPTION from mysecondtable;

I have checked the security rule :

Initial data reduction based on section access and Strict Exclusion

When i use ADMIN it works.

But when i use super or user, i can't open the document ..

Why ?

if i remove Scrict exclusion i can open it but nothing is filtered for user "test" whereas France country exists ..

What am i missing ?

Thanks

problem with section access

Sun, 14 Aug 2011 12:24:40 GMT

My previous reply was incorrect but I do have the solution. You have to seperate the section access from the section application. You at an attribute to the Access which you use to specify the Application:

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, TYPE

admin,admin,admin, type1

USER,super,super, type2

USER,test,test,type3

];

star is *; //to define the symbol used for the entire dataset

SECTION Application;

LOAD *INLINE[

TYPE, COUNTRY

type1, *

type2, *

type3, France

];

OLEDB CONNECT32 TO {removed}

SQL SELECT ATTRIBUTE1,

COUNTRY,

DESCRIPTION from mytable;

SQL SELECT ATTRIBUTE2,

COUNTRY,

DESCRIPTION from mysecondtable;

Hope this helps!

problem with section access

fredericvillemi — Tue, 16 Aug 2011 05:42:44 GMT

Thanks, it works. I have understood the way i have to make my section accesses.