Skip to main content
Submitted

Semantic Model Shared Roles - SSAS Tabular

  • December 4, 2019
  • 2 replies
  • 2 views

Forum|alt.badge.img

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

Forum|alt.badge.img
  • Known Participant
  • 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


  • Community Manager
  • February 26, 2021

Thanks for submitting your ideas! Your continued feedback on our product is very important to us.

We will be evaluating your input for future improvements in the product.

At the time of this posting, the current product roadmap is focused on a major evolution in foundational pieces of our software including splitting the development into ODX, MDW, Semantic Layer and User Portal. With this evolution, we will continue to see incredible innovation in the product that may exceed your expectations or make the need for this feature obsolete.

If you have any questions or would like to discuss further, please reach out to me or the dedicated TimeXtender Solution Specialist in you region. Thanks!