I have a Board for a user that has a number of summary tables and a transaction list. I want the summary tables to include all departments but i want to omit a department from the transaction list.
currently it out in the view but recently realised that the user can remove that filter.
how can i resolve this issue?
Hi
Filters aren’t designed for security since users can change or remove them.
To handle this I would suggest to setup Data Access Rights on the Transaction List by Department.
Then use RESETACCESSRIGHTS function when aggregating data from the TL in order to have all the departments in your summary tables.
Please make sure that using this function doesn’t have impacts elsewhere in your model as it resets access rights and will expose data.
Julien
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.