Security Role ignore

[Aue]

I have create a role using a custom MDX in one of the dimension. After I create and test the role everything works fine.
I create another user without administrator rights to test the security but the security role seem to be ignore. I tested in Analysis Manager and Excel pivot tables
I also have SP3 and AS is running in Windows 2003 Server

Am I missing something

 

[MDXer]

did you assign the user to that custom security group?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Aue]

Yes the user test is on the security role.

 

[Aue]

In addtion I tested the role in MDX applying the same fileter that I am using in the role and It works
select {[Measures].[Total Pcs],[Measures].[Total Servers]} on columns,

{Filter([Account].[Company Name].members, (strtotuple (mid (USERNAME , INSTR ( 1, USERNAME,"\")+ 1 , 128)), [Measures].[SFAccess] ) = 1)} on rows

FROM AcctDeployOpp