Hi Guys - hope you can help!

I have the following cube dimensions:

Product (Department, SubDepartment, Product - Members)
Store (Store Type, Store Name - Members)

I wish to apply the following security; All users across stores can view
data to the Sub Department Level. At Product level, only a store member
(with the store role assigned) can view data. It is almost as if I need to
apply Dimension Security on the Product Dimension, but based on store. I
know I can create a 3rd dimension which just holds store and product (and
lock this one down with dimension security), but I know that nesting each
product by Store Name will lead to a very large dimension (ie lots of stores,
lots of products).

Can anyone help me here?

Hi Carrie,

Looks like you need to use cell security. You can either create as many
roles as there are stores (more on this in a sec) with an expression like
this:

Product.Currentmember.level.ordinal <= Product.SubDeparment.Ordinal
OR
Store.[Store Name] IS <store that this role is permitted to see>

Alternatively, you could set up a single role and determine what store the
user was from using the username function. (Use this approach if you have
more stores than roles you want to have to manage).

Hope this helps,
Richard

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Carrie Taylor" <CarrieTaylor (AT) discussions (DOT) microsoft.com> wrote