How can I configure SSAS Role to restrict access to cube cells?

hi,

i need restrict access cube data different ssas roles. have tried adding mdx expression ssas role not work.

below details:

1) have cube single measure "sales"

2) have multiple dimensions "dimcustomers", "dimproducts"

3) create 1 ssas role per customer , configure role able query cube , see own tuples.

4) adding mdx expression "[dim customer].[customer key].&[1]" to 

        * ssas role/properties/dimension data

        * ssas role/properties/cell data

shows either no data or data customers in cube. need configure ssas role dimcustomer.customerkey=1 see tuples sales regardless of dimension selected.

could please advise?

best regards,

alex

 

the problem goes away if add "[dimcustomers].[customer key]"

is there easy way restrict user in ssas role reading other users cobe cells without adding "[dimcustomers].[customer key]"?

i'm not sure mean this. can explain add fix issue?

if have allowed set of "[dim customer].[customer key].&[1]" , visual totals ticked , no other roles active should see data customer key 1 regardless of other dimensions accessed.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

SQL Server  >  SQL Server Analysis Services