|
Home > Archive > MS SQL Server OLAP > August 2005 > Dimension Security advice needed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Dimension Security advice needed
|
|
|
| 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
| |
| Deepak Puri 2005-08-31, 3:24 am |
| 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[color=darkred]
Support WebCast: Dynamic Dimension Security in Microsoft SQL Server 2000
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.
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
| |
| Dave Wickert [MSFT] 2005-08-31, 3:24 am |
| 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@online.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@verizon.net> wrote in message
news:1125438582.079776.212190@g47g2000cwa.googlegroups.com...
> 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
>
|
|
|
|
|