This article is contributed. See the original author and article here.

Picture1.png


 


 


The Same KPIs, Different Department


 


Scenario: You have different managers requesting to see the same KPIs (Customer Count, Revenue Generated, Products Performance, etc) for their different region. Data privacy requires that the various managers only see reports for their regions. A simple way to think about this is by creating different reports for the managers making a total of 3 Reports. 


 


I am sure you will agree with me that this isn’t effective. more efforts and it is not scalable. what if it is a large multinational – country manager, regional manager, group manager, unit head, team leads all across the world? will you also build different reports for over 500 people? With Row Level Security, you can easily address this challenge by building a single Reports and set roles and rules to filter what everyone can see.


 


 


Learn and Practice Along here:


 


 


 


Additional Resources



 


 

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.