SSAS cell permission I'm trying to restrict the access to the cube to certain dimension members. I Used the following function on the "Cell Data" tab of the role editor:

[Magatzems].[Codi Magatzem].CURRENTMEMBER = [Magatzems].[Codi Magatzem].&amp;[27] or [Magatzems].[Codi Magatzem].CURRENTMEMBER = [Magatzems].[Codi Magatzem].&amp;[57]


and it works ok on the members, but I don't get my totals calculated.

What am I doing wrong?

Thanks.
I was doing it the wrong way. It's not in the "Cell Data" tab, It's in the "Dimension Data" tab. The "Enable Visual Totals" checkbox has to be checked.