Hi, I need some help please.
In SSAS I have created a Dynamic role which restricts the Id on the measures dimension under the Dimension Data. The MDX code behind it works fine.
When I view the data in the Browser without selecting a role I can see all the members under the Dimension, which is correct. However when I impersonate a user (change roles) I see no members under the Dimension even though they should have access to some members (see image attached). When I drag the measures into the query window it give me the overall value for that users, but when I add the Id it returns No rows found, Click to execute the query message.
When I reprocessed it fully and the members for the impersonated user is visible for a bit but then they disappear again.
This is very strange can anyone help me understand why this is happening?
No Roles Selected Dynamic User Role
Thanks in advance.