confusion about SSAS security

• markusstar

  SSC-Addicted

  Points: 432

  More actions

  May 10, 2013 at 4:58 pm

  #293191

  hi everyone

  i am quite confused about read contingent security for cube cell data? I know that it is much stricter than read permission and that it applies to calculated members, but not much more

  can anyone please explain it further

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  May 13, 2013 at 2:31 pm

  #1614778

  markusstar (5/10/2013)

  ---

  hi everyone

  i am quite confused about read contingent security for cube cell data? I know that it is much stricter than read permission and that it applies to calculated members, but not much more

  can anyone please explain it further

  Take a look at -

  http://www.sqljason.com/2010/04/implementing-measure-security-in-ssas.html

  http://msdn.microsoft.com/en-us/library/ms174847.aspx

  In my experience cell security often comes at the cost of query performance so avoid if you can 😉

  Tommy

  Follow @sqlscribe