InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:54:15 GMT20http://www.sqlservercentral.com/Forums/Topic867537-391-1.aspxhttp://bisqlserver.blogspot.com/2009/01/advanced-dimension-data-security-with.htmlFri, 26 Feb 2010 07:51:47 GMTClarkJeffhttp://www.sqlservercentral.com/Forums/Topic867537-391-1.aspxI 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=1844However, 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.Wed, 17 Feb 2010 14:46:23 GMTCalvin Lawson