Exactly. The meaning of "*" in section access has been largely discussed, but to follow your example, I would make sure of 2 things
One is that the users can open the app, which seems to be the case.
The other regarding the "*", you need to create a line for each value you want the user to see. If this means all values, you need to create as many lines as values you have. For instance:
// Use field names and field values in UPPERCASE when they are going to be used in section access, always!
User_Reduction_Data:
LOAD * INLINE [
REGION, USER
USA, DIR\USER1
GERMANY, DIR\USER2
];
// Here's the trick: USER3 has access to ALL values in the field REGION
CONCATENATE
LOAD DISTINCT
REGION
'DIR\USER3' AS USER
FROM CountryTable.qvd (qvd); // or whatever the source it might be, RESIDENT, XLS, table in SQL, etc.
Let's say you have a new USER4 who should also see ALL countries. Now you can use the "*"
User_Reduction_Data:
LOAD * INLINE [
REGION, USER
USA, DIR\USER1
GERMANY, DIR\USER2
*, DIR\USER4
];
// Here's the trick: USER3 has access to ALL values in the field REGION
CONCATENATE
LOAD DISTINCT
REGION
'DIR\USER3' AS USER
FROM CountryTable.qvd (qvd); // or whatever the source it might be, RESIDENT, XLS, table in SQL, etc.
My suggestion when you want to use the "*" in section access is that you create a dummy value, or use an actual ADMIN user, and do this with him, then you can use the * if you need to. Conceptually, something like
Reduction_Table:
LOAD DISTINCT // the data model may have several repeated values, you only want the distinct ones
'DIR\DUMMY' AS NTNAME // any actual ADMIN account or a completely fake one
COUNTRY_CODE
FROM Table.qvd (qvd);
//Real users and admins table
// Users ADMIN and BOSS will see all countries
// User1 only ES
// User2 ES and US
LOAD * INLINE [
NTNAME, COUNTRY_CODE
DIR\ADMIN, *
DIR\USER1, ES
DIR\USER2, ES
DIR\USER2, US
];
.png "Miguel_Angel_Baeyens"){kind=avatar}
