Dynamic Dimension Security in Analysis Services (Row Level Security) without Stored Procedures

• Calvin Lawson

  SSChampion

  Points: 11030

  More actions

  February 17, 2010 at 2:46 pm

  #230066

  I need to implement dimension level security within a cube. Users need to be able to see only those members in a dimension that they have been given access to.

  As far as I can tell, the preferred method of doing this dynamically is outlined here:

  http://www.mssqltips.com/tip.asp?tip=1844

  However, the use of a stored procedure seems rather hoky. Couldn't we use pure MDX to filter this instead? I apologize if this is not enough information, but I am a little fuzzy on dimension security post SQL2K.

  Signature is NULL

• ClarkJeff

  SSC Journeyman

  Points: 76

  More actions

  February 26, 2010 at 7:51 am

  #1125586

  http://bisqlserver.blogspot.com/2009/01/advanced-dimension-data-security-with.html