0

I'm working on a power view map to display to our user. I achieved to create a map that display all the data to the user. It look like this exemple. The data source is an SSAS project. But now, I would like to filter this data depending on the connected user.

For example, we have ProductManager and TerritoryManager. The product manager can see his product on all the map, but only his product. The territory mananger can see all the product, but only on his territory.

The solution that I've found is to create an SSAS project for each product/territory, and after that allow some rights on this files. But this solution is impossible to maintain.

Is there a way/solution/best practice to realize this? Any help is welcome

Damien

dpfauwadel
  • 3,866
  • 3
  • 23
  • 40

1 Answers1

0

You probably just need one SSAS database. You can set security in the SSAS project. If you are using SSAS multidimensional, see here. For tabular, see here.

As long as you have Kerberos configured, you can have one Power View map and one SSAS source. Then when the user accesses the report, their credentials are passed along with the query, and only the data they are allowed to see will be returned. This will meet the needs you described.

You'll probably want to add a table to facilitate dynamic security. You'll need some way to tie product managers to the products they own and territory managers to the territories they own. You add this to the data in the SSAS model. And then use it to set security. Other than setting the data source for Power View to use Windows authentication, no changes are required to the report.

mmarie
  • 5,598
  • 1
  • 18
  • 33