Hi,

I am using SQLServer 2000 Analysis Services and very new to this and MDX.

I have a sales cube with sales and cost data for different countries. I
want to hide-show Country and Cost data based on user role.

I have created Country_A_WithCost, Country_A_WithoutCost,
Country_B_WithCost, Country_B_WithoutCost roles.

It works fine when I assign a user to a group, but if a user belong to two
different groups that is not what I expected.

For example.

If User is in Country_A_WithoutCost role, s/he only can see Country A Sales
without Cost (by restricting country dimension and by restricting
measures.)
If User is in Country_A_WithoutCost and Country_B_WithoutCost role, s/he
only can see Country A and B Sales without Cost (by restricting country
dimension and by restricting measures.)

But when I assigned user to Country_A_WithoutCost and Country_B_WithCost
s/he can see both country A and B sales with cost data. I would expect s/he
can see Country A sales without cost and Country B Sales with cost.

Probably it is a simple issue but I cannot see.

Could somebody help on this.

thanks in advance

erdal

I have solved the problem removing dimension security and implementing cell
level security.
For each role I have added an MDX to check columns and rows.

For Country A Cost Role
(Measures.CurrentMember.Name="Sales" OR
Measures.CurrentMember.Name="Cost" OR
) AND
Country.CurrentMember.Name="Country A"

For Country A without Cost Role

(Measures.CurrentMember.Name="Sales" OR ) AND
Country.CurrentMember.Name="Country A"

and repeated for other roles for other countries.

works well

erdal



"Erdal Akbulut" <erdalim21 (AT) yahoo (DOT) com> wrote