problem with section access

[fredericvillemi]

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

[#2 · Accepted solution]

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!

[fredericvillemi]

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