Re: restricted dimensions

#1

Quote:

I have a cube that has a dimension called Division. I want to restrict a
particular user so that he only sees 1 of the Divisions - easy enough to
do
with Roles.
I'm using OWC as my cube viewer. When I log in as this user, he correctly
only sees the 1 Division that I've given him access to. The problem that
I'm having however, is that if I have Subtotals turned on, which is the
default behavior for owc, the total includes numbers from the other 2
Divisions that this user doesn't have access to - and can't see. Is there
any way to prevent this?

You need to enable visual totals in the definition of the dimension
security. It is done in the third tab in UI.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#2

Perfect! I love the newsgroups...

Thanks for your help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: restricted dimensions

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: restricted dimensions - 11-26-2003 , 10:07 PM

Re: restricted dimensions - 11-26-2003 , 11:10 PM