Hi, Im trying to reduce data based on SalesReps,
In this case im trying to reduce data based on salesreps, i have SalesRep named "TEST" in excel file.
So every time user "TEST" is opening the qvw, he should see his Sales, not everybodies. First i create the SA, then i link the User to the user in the application.
Is there something im doing wrong ?
See below script:
Excelfile:
USERID | PASSWORD | ACCESS |
TEST | 123 | USER |
ADMIN | ADMIN | ADMIN |
SECTION Access;
SA_TEST:
LOAD
upper(USERID) as USERID,
upper(PASSWORD) as PASSWORD,
upper(ACCESS) as ACCESS
FROM
(ooxml, embedded labels, table is Sheet2);
SECTION Application;
SA_LINK:
LOAD
USERID as Salesman
resident SA_TEST;