question

siera_gld avatar image
siera_gld asked

How to Set up Dynamic Security for SSAS

I have followed Dustin Ryan's (pragmatic works) video to set up dynamic security in my cube. here is the link to the video and it's got some excellent instructions on how to do this. https://youtu.be/NlNw3wYbh8E . The part for dynamic security is the last 15 minutes. When I Use SSMS to login to my cube impersonating a different role (my new "Dynamic" role) it says the cube does not exist. When I login impersonating a user in the dynamic security role (table driven) it gives me an error XML for Analysis parser: The 'domain\user' value of the EffectiveUserName' XML for Analysis property is not valid. (Microsoft SQL Server 2016 Analysis Services)
ssaseffectiveusernamessas security
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Can you please describe in more detail how you set up your security? And can you please add the mdx that is used to determine the allowed set Thanks Zvi
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.