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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Dynamic Dimension Security in Analysis...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Calvin Lawson

Posted Wednesday, February 17, 2010 2:46 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:03 AM
Points: 577, Visits: 102

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

Post #867537

ClarkJeff

Posted Friday, February 26, 2010 7:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:12 AM
Points: 1, Visits: 153

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

Post #873437

« Prev Topic | Next Topic »

Permissions