I have 2 security dilema's. I am an MDX beginner to some degree.
1) is there a way in the security roles to allow users access to only
certain measures while using dimension security ? For example I would like
the user to have access to only the 'West' region of my sales region
dimension and only the sales order total but not the cost data.

2) is there a way that I can allow users to see only data related to a
specific member of one dimension OR a member of another dimension? For
example - If the Region is West or the Product Channel is Paper.

Your assistance is greatly appreciated!
amk

I figured out number 1 - still need help on number 2

"AnnetteKramer [Vizion Solutions]" wrote:

Number 2 only seems to make sense in the context of cell data security,
rather than for dimension security. It should be straightforward to
define appropriate cell security MDX, like:
'[Region].[Region].CurrentMember is [West] OR [Product Channel].[Product
Channel].CurrentMember is [Paper]'

http://msdn2.microsoft.com/en-us/library/ms174590.aspx

The Multidimensional Expressions (MDX) expression that sets permissions
to cell data can either specify which cells can be accessed or which
cells cannot be accessed. By allowing access to cells for specific
members in some dimensions and denying access to cells for specific
members in other dimensions, cell security provides great flexibility.
In fact, you can create an MDX expression that allows or denies access
to any possible combination of cells.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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