Home Dashboard Directory Help
Search

Invisible measures could not be managed in SSAS role dialog by NilsRottgardt


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 802200
Opened: 9/25/2013 4:14:05 AM
Access Restriction: Public
0
Workaround(s)
view

Description

TITLE: Invalid Member Unique Name
------------------------------
In many cases it is necessary to grant access to not visible measures. E.g. some technical measures that are used for calculated measures only. In this case access have to be granted also. But the role manager in SSMS does not support non visible measures and also shows the following dialog to delete it from the role if they are added manually. If the users clicked &Yes the security definition is destroyed. So it is easy to break the security settings.

Dialog:
The '[Measures].[Net Rev007]' member unique name specified in the attribute permission is no longer valid.

Do you want to remove it?

------------------------------
BUTTONS:

&Yes
&No
------------------------------
Details
Sign in to post a comment.
Sign in to post a workaround.