Hello...hope someone can lend their expertise here.

All my cubes use the shared dimension Location which has the levels
Location and Account number. In the application, users are set up and
given access to any number of these Locations. A security table exists
in the application listing each user and the Locations they have access
to (which changes often).

I need to set up security in my cubes to allow a user to view only
those Locations that he has been given access to in the application but
am at a total loss of how to go about it (total newbie here). From
reading posts here, it looks like dynamic dimension security using the
USERNAME function is what I need. Do I create another dimension based
on the security table? Then I would have Location in two different
dimensions. Or do I work in the security table into the present
Location dimension? Any guidance would be appreciated!
Mara

Dynamic dimension security, using the virtual cube approach, may work in
this scenario. This Microsoft Support Webcast discusses different
dynamic security solutions:

http://support.microsoft.com/default.aspx?kbid=828343
Analysis Services

Article ID : 828343
Last Review : August 4, 2004
Revision : 1.0

Session Summary

Wednesday, September 3, 2003

This Support WebCast session discusses how to implement dynamic
Dimension Security in Microsoft SQL Server 2000 Analysis Services. It
reviews some popular approaches to use during implementation. It also
talks about common issues that may occur and how to resolve them.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

A couple of very useful resources:
http://www.mosha.com/msolap/security.htm
http://www.mosha.com/msolap/samples/...20security.zip

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Mara" <mrscnln (AT) verizon (DOT) net> wrote