Dynamic Security for dimensional members?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Dynamic Security for dimensional members?

Dynamic Security for dimensional members?

Rate Topic

Display Mode

Topic Options

Author

Message

ProKelly

Posted Sunday, January 06, 2013 4:27 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 8:46 AM
Points: 87, Visits: 526

Ok so here's the problem.

I have a corporate BFC (big fat cube) which some 20 different services access and within that several hundred employees. I want to employ 4 stage security, ie, for each dimension I have 4 roles, 1 = only very general stuff 4 = everything.

The problem is I also only want each user to be able to see stuff within their service. I have a service dimension, which lists employees and service. How can I have it dynamically restrict access to only the service the employee is currently working in?

Post #1403371

davoscollective

Posted Sunday, January 06, 2013 11:54 PM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:31 PM
Points: 413, Visits: 703

Chris Webb did a good article on this for something similar a while back which might help:

http://cwebbbi.wordpress.com/2011/12/22/replacing-cell-security-with-dimension-security/

I'm not sure that a dimension mapping every single user to services will be practical, nor creating all four of your roles for each service but you might have to. It's probably going to be better than creating subcubes for each service.

Post #1403428

« Prev Topic | Next Topic »

Permissions