Share via

Add measure security for a role in SSAS

sudipta sen 1 Reputation point
2020-09-12T16:47:54.407+00:00

I need to add measure security programmatically in Saas. I can do it manually by going to the role and then navigating to measures dimension and add/deny access to individual measures.
But how do I access these classes and methods through code.
Please help

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. sudipta sen 1 Reputation point
    2020-09-12T18:03:52.267+00:00

    I am trying with AMO objects but could not find measure dimension to set measure security for that role.

    0 comments
  2. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-14T09:52:08.807+00:00

    Hi,

    According to your description, there is a similar issue for MOLAP like your case. We could try programmatically add measure security like this SSAS - Add users to cube rules automatically
    See if this gives any direction.
    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.