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,006 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  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.

    No comments

  2. Lukas Yu -MSFT 5,796 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.