Hello,

I create a Database and Cube functions that allow to view only 1 of 3 members
(My Dimension is Enterprise, and the function allows to view only 1
Enterprise)

When I put TEST FUNCTION all goes well. But when I use MS Excel (2003) to
view is the function is implemented, I view all members of the dimension, in
stead of only 1.

I tried to assign this to my account, to a group and for user ALL, and still
not work.

Can you help me? Thanks.


--
Message posted via http://www.sqlmonster.com

If your user account is in OLAP Administrators, then security does not
get evaluated. You will always have access to every member in every
dimension.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

And another thing to remember is that if the user is a member of multiple
roles then the resulting allowed set is the UNION of the permissions from
the various roles. Here is a sample thing to show you with FoodMart. Create
three roles: one which can only see USA, one one Canada, one only Mexico.
You will notice a user in all three roles can see everything.

A common role in a cube is the Everyone role which allows everyone to see
everything. You might want to check and ensure that it isn't present in your
cube.
--
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.


"Darren Gosbell" <xxx (AT) xxx (DOT) com> wrote