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 = "<MEMBERSECURITY >" & _<br /> "<<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ERMISSION Access=""Read"" " & _<br /> "DeniedSet=""{[Measures].&[SCost]}""" & _<br /> "Description=""test measure""/>" & _<br /> "</MEMBERSECURITY>"<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 />]]>