Hi, all.
Question:
- I want to restrict users to the data only under their corresponding departments. But all the users can still have all the access even after applying the session access restriction below.
- The wield thing is it worked a few moth ago with the same code and data. But no matter how many times I tried now, I can't restrict the data access to users any more.
- Please help me figure this out if you encountered same issue or similar issue before.
Session Access Code:
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION
USER,MZHAO,FINANCE
USER,ECHAO,SALES
];
section application;
T1:
LOAD
Key,
Upper(Department) AS REDUCTION
[lib://DOWNLOAD/TestData.xlsx]
(ooxml, embedded labels, table is Sheet1);
TestData Sample:
| Key | Department | Month | Volume |
| 1 | Finance | Jan-20 | 10 |
| 2 | Finance | Feb-20 | 15 |
| 3 | Finance | Mar-20 | 22 |
| 4 | Finance | Apr-20 | 30 |
| 5 | Sales | Jan-20 | 18 |
| 6 | Sales | Feb-20 | 23 |
| 7 | Sales | Mar-20 | 19 |
| 8 | Sales | Apr-20 | 61 |
