December 23, 2002 09:23 PM

Customizing Dimension Security

A virtual cube can provide flexible, scalable security
Rating: (0)
SQL Server Magazine
InstantDoc ID #27305
You often need to give OLAP cube users access to different kinds of data and restrict their access to other data. For example, in a sales organization, you might want each sales person to be able to access only the parts of the OLAP cube that correspond to his or her area of responsibility. Sales organizations aren't the only businesses that need this capability: Decision makers in various fields need access to database information to make informed decisions, but only part of that information m...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Can you update this for SSAS 2005? Since virtual cubes are no longer implemented, this probably falls under the many-to-many dimension.

J8/30/2006 10:43:37 PM


This works if the user is selecting something below the ALL level. What if you want to retain an "All" level containing ONLY the members the user has access to?

SCOTT10/20/2004 10:06:58 AM


How about memory usage with this approach?
Will analysis server create a replica dimensions for each user? Just like role recurity?
Thanks.

JOEL6/23/2004 9:11:12 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS