Hi,
Requirement 1 : One Team manager can’t see the data for other Team Manager.So we implemented a Row level Security on SSAS cube, based on users.
But now we have a new requirement to fulfill : a Team manager want to look for the historical data of his team or an specific agent to provide feedback, the data is trunked due to the Row level security
Example :
Manager 1 : Employee1, Employee2, Employee3 in 01/2021
Manager 2 : Employee4, Employee5 in 01/2021
Maanger 1 : Employee1,Employee2 in 02/2021
Manager 2 : Employee4, Employee5, Employee3 in 02/2021
If the manager 2 connected, he can't see historical data for the employee3 in 01/2021
Can you please help me to solve this problem.and have a dynamic row level security.
Thank you for your help.