Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dynamic Dimension Security in Analysis Services (Row Level Security) without Stored Procedures Expand / Collapse
Author
Message
Posted Wednesday, February 17, 2010 2:46 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr 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
Posted Friday, February 26, 2010 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 3:10 PM
Points: 1, Visits: 188
http://bisqlserver.blogspot.com/2009/01/advanced-dimension-data-security-with.html


Post #873437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse