SQL Server Performance

measures security using analysis server programmin

Discussion in 'Analysis Services/Data Warehousing' started by Player1005, Mar 29, 2004.

  1. Player1005 New Member

    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 />

Share This Page