measures security using analysis server programmin | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

measures security using analysis server programmin

Hi,<br /><br />perhaps someone can help me…<br />I want to restrict a measure at cube level.<br /><br />i am using this sytax:<br /><br /> smeassureSecurity = "&lt;MEMBERSECURITY &gt;" & _<br /> "&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ERMISSION Access=""Read"" " & _<br /> "DeniedSet=""{[Measures].&[SCost]}""" & _<br /> "Description=""test measure""/&gt;" & _<br /> "&lt;/MEMBERSECURITY&gt;"<br /> .SetPermissions "dimension:measures", smeasureSecurity<br /><br /><br />but this doesn’t work.<br />this syntax works fine with measures security.<br /><br />can someone help me?<br />am really frustrated!!<br /><br />thx in advance!<br /><br />
]]>