I work for a bank with have a lot of branches/agencies. We're willing to implements a new BI solution in our company.
The data from all branches is in the same database. I need a BI solution that allows me to create web reports templates and return the data according to the branch.
For instance, if the manager of the branch XYZ access the BI, he can see all the reports and views but only the info of your branch. He cannot see the data from the other branches.
The company have + 800 branches so it's impossible to create each report 800 times.
Keep in mind, the company uses Microsoft solutions as Windows Server, SQL Server, ASP.NET sites and etc.