Skip to main content
SUBMITTED

Semantic Model Shared Roles - SSAS Tabular

  • December 4, 2019
  • 2 replies
  • 27 views

Forum|alt.badge.img+1

Microsoft implemented security in a different fashion with SSAS Tabular when compared with Multi-Dimensional.  With multi-dimensional we had the database concept with multiple cubes... but a security role could be defined and used across all of the cubes in the database.

Tabular is a bit frustrating in that we have to create a role and define role membership for each model.  But this could be TimeXtender's time to shine!! :)

I'd like to propose the ability to create a shared security role for the Semantic Models.  A role could be defined with membership applied, and that role can then be linked to the models where security can be further defined.  Essentially, the shared role would provide a centralized membership list rather than having to recreate it for each model.

We have 7 models which are typically deployed and it can be a bit of a hassle to maintain membership lists in 3 environments for each role in each model.

Yes, we can do this with AD Groups... most of the time.  That capability doesn't really work with Azure Analysis Services, so it becomes very painful there. 

2 replies

peter.jensen
TimeXtender Xpert
Forum|alt.badge.img+3
  • TimeXtender Xpert
  • December 4, 2019

In the meantime, please add object security as well (tables, columns, measures) - which is available in SSAS tabular, but not in Discovery Hub.

Best Regards,

Peter


Forum|alt.badge.img
  • Contributor
  • October 24, 2024

This idea should be higher up. I have multiple Semantic Models with tons of different roles. It’s absurd I have to manually recreate every role for every semantic model again and again. It’s so time consuming every time.

It would be great to have a place to create and manage roles and reuse these roles across several Semantic Models!