Hi Experts ,
SSAS Dynamic security is working (when Roles is selected in browser) . Basically , there are three options when browsing the Cube from SSMS.
1. Current User
2. Other User (can enter LoginID here)
Precisely , security is not working for Option 1 and 2 , but working for Option 3 (mentioned above).
I understand that the security works always based on the role and it works apparently because the security definition is provided for the role in SSAS (in allowed member set).
Please Note : I have not created any role, I am using the default role in SSAS.
I am not sure how the security works when option 1 /Option 2 is selected in cube browser(Change Users) . Can you please shed some light on this issue ? Will appreciate.
I have a security document which explains how I have implemented the Dimension security (by role ) . Also , please see the screen shots for the Issues.
Your quick resolution to Option / Option 2 is greatly appreciated in this regard.